Is my diagram correct based on this information, and if not, what changes should I make to make it compatible with the entity-entity relationship? 

List of Major Entities and Description

• Restaurant: Contains regular information about the restaurant.
• Order: Contains information about how to complete the order, time, ID, type of order, delivery, takeout, or dine-in.
• Employees: Contains information about each employee, such as their names and addresses.
• Menu Items: Contains information about the list of items on the menu, their description, prices, names, and ingredients of each dish.
• Customer: It contains information about all customers who have visited the restaurant once before, such as their names, addresses, and payment information.
• Reservation: Contains information about the date and time of the reservation and how to organize the reservation by giving each reservation and ID.
• Tables: It contains information about the table, divided into different types of tables according to the number of guests, and each table has a number.
• Order Line: Captures the individual items that make up an Order, with details like Menu Item, quantity etc.

 

 

 

 

 

Entity to Entity Business Rules

1. A customer can make reservations. 
2. A Reservation is made by one Customer.
3. A Table can have many Reservations.
4. A Reservation is for one Table.
5. An Employee can take multiple Orders.
6. An Order is taken by one Employee.
7. A Customer places an Order.
8. An Order is placed by one Customer.
9. A Menu contains many Menus Items
10. A Menu Item appears on one Menu.
11. An Order contains many Orders Lines
12. An Order Line contains one Menu Item.
13. An Order Line belongs to one Order.
14. A Menu Item can appear on many Orders Lines

 

Transcribed Image Text:

cus_info Customer H Makes employee info cus_id (PK) date and time Employee Reservation Places booking_id (PK) employee_id (PK) Takes has order_id (PK) Order HH order_date item id (PK) (item_description item price Order Amt table details has Menu Tables order_id Table_id (PK) orderline id (PK) order_composit key order_line constains quantity order_line total cus_info Customer H Makes employee info cus_id (PK) date and time Employee Reservation Places booking_id (PK) employee_id (PK) Takes has order_id (PK) Order HH order_date item id (PK) (item_description item price Order Amt table details has Menu Tables order_id Table_id (PK) orderline id (PK) order_composit key order_line constains quantity order_line total