ER Diagram Help

Discussion in 'Database' started by p4i, Apr 16, 2012.

  1. p4i

    p4i New Member

    Apr 16, 2012
    Likes Received:
    Trophy Points:
    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:

    • ERD.doc
      File size:
      384.5 KB

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice