Draw a complete Entity Relationship Diagram $($ERD$)$ for the following.

Perfect Pizza is a pizza delivery shop. They only create pizzas for home delivery.

They have recently designed a new database to track their sales. They use the

customer$$s telephone number for a Key column in the Customer table.They are

interested in households, not individuals. They need the street address and zip

code for the delivery. They only deliver to three zip codes: M$1$G$2$V$5,$ M$1$B$6$H$9,$

and M$1$B$6$K$2.$With the zip code, they can fill in city and state information later,

though they prefer to do it when they enter a new customer. In the OrderDetail

table, they store the price charged for two reasons: First, it may be different than

product price due to a discount or special allowance, and second, it keeps a

historic record of the price. That way, if they change the price in the product

table, it doesn$$t affect the prices charged in past sales.

Hint :Entities may include Customer,Employee,CustomerOrder,Product &

ProductDetail

$1.$ Identify the Entities Related to the Above Problem

$2.$ Identify mandatory and optional attributes $($if any$)$

$3.$ Write the Relationship Matrix

$4.$ Draw the complete ERD