Question: Background As the ERD shown below, a customer can place minimum zero to maximum many orders of customized pizzas. In each order, the customers choose

Background As the ERD shown below, a customer canBackground As the ERD shown below, a customer can

Background As the ERD shown below, a customer can place minimum zero to maximum many orders of customized pizzas. In each order, the customers choose a pizza store to order different quantity of the same pizza or order different types of pizzas (the choses of size, crust, sauce, cheese, crust flavor, and topping). Except for the pizza topping, a customer can only have one choice for each of the following categories--size, crust, sauce type and amount, cheese amount, and crust flavor. A customer can choose to add multiple toppings on a pizza. The price of a customized pizza is based on the pizza size, crust type (some type charge extra), cheese amount (extra cheese), and choices of topping or extra topping. Students can refer to pizzahut.com for the ordering process. Customer Customer FirstName LastName Email Phone Size SizeNum + Size Price Pizza Order Detail PizzaODNum *Ordernum Crust Order SizeNum Order Num Order Date Cusomer Storld + Crusunum CrustType CrustExtra Price + Crustum CrustFlavorum CheeseNum SauceNum Quantity CrustFlavor + CrustFlavornum CrustFlavor E Store Storeld Store Address Store City Store State StorePostalCode StorePhone Sauce Cheese Cheese. Num Cheese_Amount CheeseExtraPrice Topping Detail Topping Detail Num PizzaODNum Topping Number Extra (Yes/No) ToppingArea (Full Half) SauceNum Sauce Type Sauce Amount Topping ToppingNumber + Topping Type ToppingName ToppingPrice Tasks 1. Based on the ERD, answer the following questions. 1) Use the format shown below to list the primary key in each entity. i. Entity name (Primary key) 2) In some entities, you can find a foreign key(s), which is (are) used to create the logical relationship(s) with another entity. List all of the foreign keys if you see them in an entity. i. Entity name (Foreign key, foreign key,...) 3) Read the ERD, explain why there are many entities connected to the Pizza OrderDetail entity. 4) There is an entity called ToppingDetail. Why is this entity needed? 5) In the ERD shown above, we assume that every order is placed online. If we want to use the database to support a system that can accept both online and walk-in orders, how would you modify the ERD? With the modification, you are able to track how many orders are placed online/walk-in and how much revenues are made online/walk-in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!