DATABASE PROJECT #8

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 phone are also entertained.
To deliver the orders we have delivery boys. Each delivery boy is assigned to specific area code. The delivery boy cannot deliver outside the area which is not assigned to delivery boy (for every delivery boy there can be single area assigned to that delivery boy).
Customer record is maintained so that premium customer can be awarded discounts.