: A restaurant manager has hired you to improve the data management practices of his restaurant....

 

Transcribed Image Text:

: 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 entrée, as well as its price. Each entrée contains several ingredients. The name of the ingredient, as well as the quantity required for that particular entrée, should be recorded. Each entrée 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 entrée was ordered. : 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 entrée, as well as its price. Each entrée contains several ingredients. The name of the ingredient, as well as the quantity required for that particular entrée, should be recorded. Each entrée 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 entrée was ordered.