Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A restaurant manager has hired you to improve the data management practices of his restaurant. Use an ER diagram to depict the following requirements.

A restaurant manager has hired you to improve the data management practices of his restaurant. Use an ER diagram to depict the following requirements. The restaurant employs a number of chefs. For each chef, you must keep track of the chef's name, address, phone number, and salary. (Do not assume that all chefs have unique names.) Each chef can prepare some entrees, and you must record the unique name of each entre, as well as its price. Each entre contains several ingredients. The name of the ingredient, as well as the quantity required for that particular entre, should be recorded. Each entre on the menu must be prepared by some chef. Entrees are ordered by customers. Each customer has a unique ID. A record is kept of each customer's name, address, and phone number. You must also record the time and date when each entre was ordered.

Step by Step Solution

3.34 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

According to the given information the ERDiagram of Restaurant Ma... 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

Step: 3

blur-text-image

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

Services Marketing Concepts, Strategies, & Cases

Authors: Douglas Hoffman, john Bateson

4th edition

1439039399, 978-1439039397

More Books

Students also viewed these Databases questions

Question

Discuss the characteristics of successful guarantees.

Answered: 1 week ago