Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

8 Catering menu and orders: You operate a commercial catering business serving conferences and other similar events. For each dish on your menu, you...

What does the ER diagram look like by hand? I know there is a many to many relationship but I don't know between which two entities it exists.

7.8 Catering menu and orders: You operate a commercial catering businessserving conferences and other similar events. For each dish on your menu,you want to store a name, description, and number of calories per serving.You do not charge customers by the individual dish, but by menu package(in the market niche you serve, your customers prefer the simplicity ofordering well-coordinated standard packages, rather than customizingtheir menus). Each menu package consists of multiple dishes, and eachdish can be in a number of different menu packages. Each menu packagehas a name, description, and price per guest. For each customer, you wantto store a name, address, city, state, zip, phone number, and contactperson name. Each customer places one or more orders, each of which isfor a single menu package. Each order also has a date placed, number ofguests, time and date of event, delivery address information (not neces-sarily the same as the customer’s address), and comments. Design a data-base to hold all this information. Draw an ER diagram, and write a databasedesign outline.
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question