Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Frederic S. Mishkin, Stanley G. Eakins

7th Edition

013213683X, 978-0132136839

More Books

Students also viewed these Finance questions