Question
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
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 customers 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: M1G2V5, M1B6H9, and M1B6K2.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 doesnt affect the prices charged in past sales. Hint :Entities may include Customer,Employee,CustomerOrder,Product & ProductDetail Note : Use Software Tool to Draw the ERD . But Upload the PDF as explained Include your name and student number in the ERD Include all the Attributes and Relationships with all the required details as expalined in the class
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started