Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Design a relational database to capture information needed by business processes Assignment Information: Your friend just started a small caf in a college town. She
Design a relational database to capture information needed by business processes Assignment Information: Your friend just started a small café in a college town. She heard that you are taking this class so she asked for your help in determining what information can be captured. You sat in the café for two days and documented the following:
The café has only three employees: your friend (who is also the owner), and two baristas. Any of them can take the order, prepare the order, and collect payment from the customer.
For example, your friend may take the order. Barista 1 then prepares the order. Barista 2 collects the money. It all depends on who is available. Since it's just a small café, it only sells coffee and tea related products and no food items. Currently, the store does not have a loyalty program so no customer information is collected at this time?
The café has only three employees: your friend (who is also the owner), and two baristas. Any of them can take the order, prepare the order, and collect payment from the customer.
For example, your friend may take the order. Barista 1 then prepares the order. Barista 2 collects the money. It all depends on who is available. Since it's just a small café, it only sells coffee and tea related products and no food items. Currently, the store does not have a loyalty program so no customer information is collected at this time?
Step by Step Solution
★★★★★
3.40 Rating (163 Votes )
There are 3 Steps involved in it
Step: 1
Relational Database Design for your Friends Coffee Shop Based on your observations heres a suggested ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started