Imagine that you have been tasked with designing a database system for a restaurant

management organization. Your goal is to create an Entity$-$Relationship $($ER$)$ model

that captures the essential entities, relationships, and attributes within this context.

Identify at least five entities that are crucial to the restaurant management system.

Examples of entities could include Restaurant, Menu, Chef, Customer, Reservation,

Supplier, Order, Employee, and Review, etc. Ensure that the entities are relevant to

the functioning of a restaurant management system.

Define at least four relevant attributes for each entity. Attributes could include

RestaurantID, Name, and Location for the Restaurant entity, or MenuID, ItemName,

Description, and Price for the Menu entity, OrderID, CustomerID, Total Amount,

Payment Method for Order entity, etc Select attributes that are appropriate and

meaningful for each entity.

Determine the relationships between the entities. Specify the cardinality and

participation constraints for each relationship. For example, a Restaurant can have

multiple Chefs, and a Customer can make multiple Reservations. Use appropriate

notations to represent these relationships.

Create an Entity$-$Relationship Diagram $($ERD$)$ to visually represent your design.

Utilize standard symbols and notation to depict entities, attributes, and relationships.

Explain the reasoning behind your design decisions. Discuss any potential constraints

or assumptions that may impact the design of the database system. Consider factors

such as reservation availability, menu updates, and supplier agreements.

Submission Guidelines:

$1.$ Clearly label and elucidate the entities, attributes, relationships, and constraints

in the ERD.

$2.$ Provide clear and concise justifications for your design decisions.