Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Presentation Aids Practicing Your Speech?

Answered: 1 week ago