Restaurant Management Database Project: The restaurant maintains the catalog for the list of food and beverage items that it provides. Apart from providing food facility at their own premises, the restaurant takes orders online through their site. Orders on the phone are also entertained. To deliver the orders, we have delivery boys. Each delivery boy is assigned to the specific area code. The delivery boy cannot deliver outside the area which is not assigned to the delivery boy (for every delivery boy there can be single area assigned to that delivery boy). The customer record is maintained so that premium customer can be awarded discounts.
- Draw an ER diagram for this database. Make sure to indicate primary keys, cardinality