Restaurant Database

[Rashid Khan]

Hello All Experts,


I have been after this for quiet some time now :-(. I want to design a
database for a Restaurant. As I am a newbie on the learning curve I need a
helping hand to guide me thru.



I have the following Tables.

RI = Referential Integrity, CU = Cascade Update, CD = Cascade Delete

1 to M = One-to-Many Relationship



Customer

-CustomerID (PK)

-other details as name, surname etc.

- StaffID (FK)

- OrderID (FK)



Table

- TableID (PK)

- TableDetails



Staff

-StaffID (PK)

-StaffName, DateofHire, etc

-StaffRoleID (FK)



StaffRole

-StaffRoleID (PK)

-StaffRoleDescription



Order

- OrderID (PK)

- OrderDate

- OrderTime

- CustomerID(FK)

- StaffRoleID(FK) (1 to M )

- MenuItemID (FK)

- TableID (FK)



OrderMenuItem

- OrderMenuItemID (PK)

- OrderMenuItemQuantity



MenuItem

- MenuItemID (PK)

- MenuItemDescription

- MenuItemPrice

- MenuItemQuantity

- CategoryID (FK) (1 to M with RI)

- OrderID (FK) (1 to M with RI, CU, CD)



Categories

- CategoryID (PK)

- CategoryDescription (eg Starters, Desserts, Cold Drinks etc. etc.)

- CustomerID (FK) (1 to M)



Payments

- PaymentID (PK)

- OrderID (FK) (1 to M with RI, CU and CD)

- PaymentAmount

- PaymentDate

- PaymentMethodID (FK) (1 to M)



PaymentMethod

- PaymentMethodID (PK)

- PaymentMethod (eg Credit Card, Cash, Check etc. )



OrderDetails

- OrderDetaisID (PK)

- OrderID (FK) (1 to M) RI, CU, CD

- MenuItemID (FK) (1 to M)

- Quantity

- UnitPrice

- Discount



This is how far I have got.

Can somebody guide me in restructuring my design. I must have missed
several basics. Pardon me for my ignorance.



Basically I want to design a Restaurant database where the Customer walks in
and places an Order from a Category (subdivided in MenuItems) which is
executed by a Staff. After the completion of the order the Bill will be
generated.



Any help or suggestions would be very much appreciated.



Rashid Khan

 

[Rashid Khan]

Further to my previous post. I am using Access 2002..

 

[Ashley]

Try this link. It is an order template. Ashley
http://office.microsoft.com/templates/preview.aspx?
AssetID=TC010185481033&CTT=1&Origin=EC790000701033&QueryID=
k-u5d42vV&Query=access&Scope=TC

 

[Rashid Khan]

Hi Ashley,
Thanks for your reply..But the link is <broken>....Can u suggest something
else?

 

[Lynn Trapp]

The link isn't actually broken, but has wrapped on to multiple lines. You
may have to select each line and paste them successively into your browser.

 

[Rashid Khan]

Hello Lynn,
This is what it says.........
Template Not Found.
The template you are trying to access was not found.

Rashid

 

[Lynn Trapp]

Then try this.

1. go to office.microsoft.com
2. In the search box select Templates from the dropdown.
3. put Access in the field to the right of the dropdown
4. click Go
5. Scroll down an dlook for Orders management database

 

[Rashid Khan]

Thanks Lynn.
Got it. I will download it and come back if there is any problem. I will
have to adapt it to my requirements though.
Rashid