Posted by hadi on 03/15/07 14:39

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 food is 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.

[Back to original message]