Data Base Consider a fast food restaurant in which employees take orders for food from customers. The data requirements are summarized as follows:The restaurant has employees, each identified by a unique employee number, first and last name.Each customer of the restaurant is identified by a unique customer number, first and last name.Each food item sold is identified by a unique number, a name, price, and quantity in stock.Each order placed by a customer is taken by an employee and is given a unique number. Each order contains specified quantities of one or more food items. Each order has a date of receipt and order time. The actual delivery time is also recorded.Construct an ER diagram for this application. (CLO 1)

Answered: Image /qna-images/answer/efcb75d9-97a6-4f34-a7e6-f34eff062d71.jpg

Answered: Consider a fast food restaurant in…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Data Base

Consider a fast food restaurant in which employees take orders for food from customers. The data requirements are summarized as follows:

The restaurant has employees, each identified by a unique employee number, first and last name.
Each customer of the restaurant is identified by a unique customer number, first and last name.
Each food item sold is identified by a unique number, a name, price, and quantity in stock.
Each order placed by a customer is taken by an employee and is given a unique number. Each order contains specified quantities of one or more food items. Each order has a date of receipt and order time. The actual delivery time is also recorded.

Construct an ER diagram for this application. (CLO 1)

Expert Solution