Use the business rules below to identify and write all appropriate relationships and cardinalities between the entities shown on the next page. Also include primary keys and foreign keys for each entity. Do not add any entities to the diagram. The data model shown on the next page depicts the entities required for a customer ordering system at a pizza restaurant. A few of the attributes and primary keys have been included on this model to get you started. This system accepts orders from customers for such menu items as pizza, ravioli, calzones, etc. This is a take-out or eat in restaurant. The restaurant keeps customer information in order to make deliveries of orders to the customer's home (or business).

a. An order is placed by only one customer. A customer is capable of placing many orders.

b. A customer is kept in the system whether or not an order for that customer is currently part of the system.

c. An employee accepts an order that is placed by a customer. An employee may accept zero or many orders, but an order is accepted by only one employee. It is possible that an order is placed directly by a customer over the phone but the customer and employee information is still stored with that order.

d. An employee delivers the order if the order is supposed to be delivered. An employee may deliver zero or many orders. The employee who accepts the order may or may not be the same employee who delivers the order. The company wants to keep track of the employee who delivers an order.

e. A menu item is an item such as a pizza or an order of ravioli. An order may have more than one menu item and each menu item may be on more than one order, so the intersection between the two is an orderline. An order has at least one order line and may possibly have many order lines. An order line is composed of one and only one menu item. A given menu item may be on many order lines.

f. A menu item is made up of one or more ingredients. A menu item must use at least one ingredient.

g. An ingredient can be used in more than one menu item. An ingredient must be used on at least one menu item to be considered part of the system.

Customer PK customerID customername customerphone Order OrderLine Menultem PK orderlD PK menuitemID orderdate quantityordered description price Employee PK employeeld name ItemIngredient Ingredient PK ingredientiD quantityrequired description cost Customer PK customerID customername customerphone Order OrderLine Menultem PK orderlD PK menuitemID orderdate quantityordered description price Employee PK employeeld name ItemIngredient Ingredient PK ingredientiD quantityrequired description cost