Learning Objective:

ACC 535 Database Practice Exercise

1. Design a relational database to capture data needed by business processes.

Information:

Your friend just started a small caf and asks for your help in determining what information can be captured. You sit in the caf for two days and document the following:

The caf has only three employees: your friend (who is also the owner), and two baristas. Any of them can do one of three tasks - 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. They all take turns in doing one of these three tasks throughout the day. Since its just a small caf, it only sells coffee and tea related products and no food items. All products in the caf have been ordered at least once except for the dandelion tea. Currently, the store does not have a loyalty program so no customer information is collected.

Instructions:

Draw a UML class diagram based on the operational processes provided above. Please limit your answer to the scope of the narrative.

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 to attach to your post for the discussion boards. 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.