Restaurant Management Database Project:

A local restaurant is in need of a way to keep track of their orders. To simplify things for

this project, let$$s assume the new database for this restaurant must keep track of the

following:

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, they 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.

This restaurant is looking to your team to deliver a database where they can manage the

data specified above.