By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Restaurant Database

P: n/a
Imagine a restaurant which we want to store information about. Two
types of people are related to it.
1) People who simply call and the foods are delivered to them.
2) People who actually come to the restaurant and eat their food
there.
For both categories, order information(OrderID, OrderDate, EmployeeID)
is stored. But for the first category the customer
information(CustomerID, Sirname, Telephone, Address) is also stored.
Could any one help on how to draw the ER diagram for this database?
Thanks a lot.

Feb 27 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Imagine a restaurant which we want to store information about. Two
types of people are related to it.
1) People who simply call and the foods are delivered to them.
2) People who actually come to the restaurant and eat their food
there.
For both categories, order information(OrderID, OrderDate, EmployeeID)
is stored. But for the first category the customer
information(CustomerID, Sirname, Telephone, Address) is also stored.
Could any one help on how to draw the ER diagram for this database?
I would have 3-Tables (EmployeeTable CustomerTable OrderTable). No pun
intended.
I would add the CustomerID field to the Order Table. Then link the
Employee and Customer Tables to the OrderTable as a one to many
relationship, and include Referential Integrity with CascadingUpdates.
Feb 27 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.