Can any one help me with the er diagram I am having problem pls can any one check it.


> Fixed No Of Tables
> Each table can hold up to 4 people
> Advance Reservation Can be made by phone or in person
> The person making the reservation will give the date and time preferred and the number of people.
> The computer system will check availability and confirm the reservation if there are sufficient tables available for that   date, time, number of people combination.
> it will be booked for a period of 2 hours.
> Customers may come to the restaurant without any reservation.

> Orders are take from wireless keyboard fixed on each table. 
> Item codes of the various items ordered (Which are shown in menu).
> If any specific ingredients are to be added to the food items, it may be indicated in the order. 
> Conformations of orders
> Orders are sent to the kitchen and are displayed on a plasma screen. 
> Once an item is ready to be served, the kitchen staff will use the kitchen terminal to indicate its readiness. 
> Waiters will receive notification of the itemís readiness and then serve the item to the appropriate table. 
> Drinks orders are relayed to an LCD screen in the bar and once again, when the drinks are ready to be served, the bar     staff will use the bar terminal to indicate this.
MY ERD is attached
Attached Files
File Type: doc ERD.doc (384.5 KB, 10 views)