Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   ER Diagram Help (http://www.go4expert.com/forums/er-diagram-help-t28200/)

p4i 16Apr2012 15:19

ER Diagram Help
 
1 Attachment(s)
Can any one help me with the er diagram I am having problem pls can any one check it.

Requirements

Code:

> 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


All times are GMT +5.5. The time now is 16:02.