Scenario:

IDK Pizza is a new concept in pizza delivery. Tom and Bob arethe owner. Instead of focusing on an ever-increasing variety ofspecialty pizzas, the they have decided to turn the value concepttoward the high-volume, late-night pizza-delivery business.Certainly, being close to IDK University, home of the IDK, and its38,000 students provides a deep and growing market for theirbusiness. As such, the Tom and Bob are creating IDK Pizza to selland deliver pizzas only between 12:00- 4:00 a.m. No other businessis currently targeting that same market. Tom and Bob believe thatthe simplest business model will bring them the best success.

The new restaurant will not have any seating (as most orderswill be delivered), but it will allow for pickup of pizzas ifneeded.

It will also have a limited menu of pizza types (thin, regular,or pan) and a limited topping list (pepperoni, sausage, ham, andextra cheese) in order to facilitate the high sales volumeexpected.

Tom and Bob also want a comments area for specialinstructions.

Fixed their prices as follows: ? Thin and Regular Crust: $13.00? Pan Pizza: $15.00 ? Toppings: $2.00 each

Tom and Bob would like to: track orders by phone number, streetaddress, city, state, and zip code.

I have been asked to design a database that can track thefollowing details:

Pizza orders, including toppings added.

Customer who ordered pizza.

Address pizza was delivered to.

Name and phone number of employee who delivered pizza.

Name of employee who took pizza order.

Sales per hour, day, week, and month.

Delivery status details at various points in the night.

Each order should have a status along with the order date andtime and the delivery date and time.

Note that if a customer picks up the pizza, the pickup time isthe delivery time.

Considerations:

A customer can certainly order more than one pizza.

Customers move often and may order from different locations (afriend’s house ,for instance), so address details may also changeoften. However, each customer would have one primary address.

Most orders completed and delivered within an hour.

QUESTION:

A. Construct your ERD, utilizing your identifiedentities and attributes.

B. Determine appropriate primary and foreign keys foreach entity and note them on your ERD.

C. Determine table relationships and note them on yourERD.

D. Determine appropriate data types and sizes for eachattribute and note them on your ERD.