Learning Objective:

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

Assignment Information:

Your friend owns a Chinese restaurant. The business is growing, and your friend asks for your help in designing a database for capturing the data needed for her business. You sit in the restaurant for several days and document the following:

The Chinese restaurant has dine-in or takeout. There are three employees that run the business including your friend. The employees take turns each day doing each job except for takeout (which will be further discussed below). One job is cooking and preparing the food which is handled by one employee. Another employee handles the job for dine-in customers (including seating, taking orders, serving, accepting payment, and cleaning up). Dine-in customers have choice in seating through the restaurants mobile app or a touch screen at the entrance of the restaurant with each table being numbered 1-20. Dine-in customers also have the option to reserve their table ahead of time in the restaurants mobile app. Customers can request the server to sing Happy Birthday if its someones birthday. All menu options (e.g., Egg Drop Soup, Kung Pao Chicken, etc.) have been ordered multiple times. Another employee handles the take-out job (including taking the order, packaging the order, and processing payment). Out of the three employees, one (your friend) does not handle takeouts. Orders placed for takeout can be either for in-person carryout or delivery. Delivery is made by a third-party app (such as Grubhub, Uber Eats, or DoorDash) that is not kept track of by the restaurant other than whether an order was for delivery. Takeout options include whether to have utensils (e.g., chopsticks and spoons), condiments (e.g., soy sauce), or fortune cookies. There is also a priority option that customers can pay extra to have their order be cooked and prepared within 30 minutes for takeout. All payments are made with either cash or credit card. The restaurant does not have a loyalty program and so no customer information is kept. Customers, whether dine-in or takeout, have the option to customize the dishes they order such as no MSG, Sichuan style (spicy), etc.

Instructions and deliverables:

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.

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,