If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Restaurant Database
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 |
#2
|
|||
|
|||
Restaurant Database
Further to my previous post. I am using Access 2002..
"Rashid Khan" wrote in message ... 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 |
#3
|
|||
|
|||
Restaurant Database
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 -----Original Message----- Further to my previous post. I am using Access 2002.. "Rashid Khan" wrote in message ... 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 . |
#4
|
|||
|
|||
Restaurant Database
Hi Ashley,
Thanks for your reply..But the link is broken....Can u suggest something else? "Ashley" wrote in message ... 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 -----Original Message----- Further to my previous post. I am using Access 2002.. "Rashid Khan" wrote in message ... 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 . |
#5
|
|||
|
|||
Restaurant Database
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. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Rashid Khan" wrote in message ... Hi Ashley, Thanks for your reply..But the link is broken....Can u suggest something else? "Ashley" wrote in message ... 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 -----Original Message----- Further to my previous post. I am using Access 2002.. "Rashid Khan" wrote in message ... 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 . |
#6
|
|||
|
|||
Restaurant Database
Hello Lynn,
This is what it says......... Template Not Found. The template you are trying to access was not found. Rashid "Lynn Trapp" wrote in message ... 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. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Rashid Khan" wrote in message ... Hi Ashley, Thanks for your reply..But the link is broken....Can u suggest something else? "Ashley" wrote in message ... 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 -----Original Message----- Further to my previous post. I am using Access 2002.. "Rashid Khan" wrote in message ... 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 . |
#7
|
|||
|
|||
Restaurant Database
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 -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Rashid Khan" wrote in message ... Hello Lynn, This is what it says......... Template Not Found. The template you are trying to access was not found. Rashid "Lynn Trapp" wrote in message ... 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. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Rashid Khan" wrote in message ... Hi Ashley, Thanks for your reply..But the link is broken....Can u suggest something else? "Ashley" wrote in message ... 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 -----Original Message----- Further to my previous post. I am using Access 2002.. "Rashid Khan" wrote in message ... 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 . |
#8
|
|||
|
|||
Restaurant Database
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 "Lynn Trapp" wrote in message ... 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 -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Rashid Khan" wrote in message ... Hello Lynn, This is what it says......... Template Not Found. The template you are trying to access was not found. Rashid "Lynn Trapp" wrote in message ... 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. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Rashid Khan" wrote in message ... Hi Ashley, Thanks for your reply..But the link is broken....Can u suggest something else? "Ashley" wrote in message ... 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 -----Original Message----- Further to my previous post. I am using Access 2002.. "Rashid Khan" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |
Database periodically needs rebuild and locks users out | spectrum | General Discussion | 2 | July 13th, 2004 06:24 PM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |