Practice Exercise: ER Diagramming - Pizza Delivery Shop

Examine the Following Scenarios in a Business Setting

Create an ER Diagram Based on these Requirements

A Staff member takes orders from customers.  A staff member may take many orders for many customers.  The pizza shop keeps track of customer names and phone numbers for identification. Order staff are identified by name and employee number.

Delivery drivers are assigned to orders to deliver the Pizzas to customers placing the order.  The Pizza shop keeps in contact with delivery drivers through cell phones. The pizza company shop keeps track of the model of the car that the delivery person must notify the customer for assurance.

The pizza shop keeps track of the date and time of an order.  Every order is assigned an order number for tracking.  

An order may have multiple items ordered at the same time.  The only items that the pizza delivery shop sells are pizzas.  Pizzas may have different toppings added to the pizza. Different toppings have different prices.  Pizzas come in a variety of sizes (small, medium, large and extra large).  Different size pizzas have different prices.

Create an Entity-Attribute-Relationship Diagram (ERD) to represent the conceptual model of a database that could connect the transactions in these scenarios. Create any entities that would be needed, create any associated relationships need to illustrate the scenario. For each entity  you illustrate, add 3 to 5 attributes,   Identify the primary keys and the foreign keys that you would use. Remember, include a couple of descriptive attributes for any Entity or Relationship items in the diagram that you think may help identify them. Remember for this assignment, we are only concerned with the (EAR) segment of modeling. Identify the Entities, their Attributes, the Relationships associated with the each entity. Connect these items using a connection line. We also discussed carnality; try to identify the carnality in the relationships. 

Submit a PDF file containing the ER Diagram

Framework for Creating ER Diagrams (ERD)

https://www.screencast.com/t/U1h9faVuGL Links to an external site.

Extracting Entities from the Requirements for the Pizza Delivery Database 

https://www.screencast.com/t/DX6m06JIcZI1 Links to an external site.

Associating Entities with Attributes in the Requirements

https://www.screencast.com/t/mhdrv778L Links to an external site.

Selecting the (Primary Key - Entity Identifier) for Each Entity  of the Practice Database

https://www.screencast.com/t/1m9gC9AH1 Links to an external site.

Illustrating Relationships and Carnality 

https://www.screencast.com/t/CycGPbxSe8y Links to an external site.

Mapping the Foreign Keys for the Practice Database Pizza Delivery Shop 

https://www.screencast.com/t/RzMFA7ou6T1J Links to an external site.

Adding a Text Label and Saving your Final ER Diagram

https://www.screencast.com/t/UUzBjQ3OP4a Links to an external site.