Question
Learning Objective: 1. Design a relational database to capture information needed by business processes Assignment Information: Your friend just started a small caf in a
Learning Objective: 1. 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 its 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. Instructions and deliverables: This is an individual assignment. No late submissions will be accepted. Draw a UML class diagram based on the operational processes provided above. Note that this is a simplified narrative given the limited time that we have for an assignment. Please limit your answer to the scope of the narrative. It is not necessary to expand it to a complete sales process for a caf. You may submit a hand-drawn diagram but please ensure it is clear and readable. You can also use any modeling software to draw the class diagram. After completing the diagram, convert it to a PDF file for submission on D2L. Please note that image files may not work as expected on D2L so a PDF submission is better. For each class and linking table (if any) in the UML class diagram, you need to (1) clearly identify the primary key, (2) clearly identify the foreign key, if any, (3) give at least 2 attributes other than the primary key and the foreign key for classes and at least 1 attribute other than the primary key and the foreign key for linking tables for the many to many relationship, and (4) explain each multiplicity clearly as to why you set up the multiplicities in a certain manner based on the processes. Given that there is no one single solution for this type of project, I will compare your diagram with the narrative above and see whether your diagram captures the data needed. You lose 3 points for each missing or erroneous data capture and 1 point for each erroneous notation.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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