Create a logical ERD for each of the problems below using the crowsfoot notation. Be sure that each entity has the entity name at the top of the box, the primary key attribute or attributes in the middle of the box, and the non-key attributes in the bottom of the box. Lines should separate each part of the entity box. The ERD should not include any M:N relationships and all attributes should be placed within an entity. Each entity must have a primary key defined. A primary key may consist of one of more attributes. Each relationship should have at least one relationship verb or verb phrase. Please include all required foreign keys and denote the foreign key(s) with the notation (FK) on the ERD. I recommend that you NOT use Visio for this assignment but do make the diagrams readable.

2.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. Note: it is possible to have more than one relationship between two entities 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) An order is placed by only one customer. A customer is capable of placing many orders. A customer is kept in the system whether or not an order for that customer is currently part of the system. 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 related to that order 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 employee who delivers the order. The company wants to keep track of the employee who delivers an order a. b. c. d. 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 e. 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