Normalizing a Pizza Delivery Database. The following tables (with only some of t

Question

Normalizing a Pizza Delivery Database. The following tables (with only some of the rows shown) are part of the information system Checkers Pizza uses to track its home delivery business. The interpretation of the data shown is: On November 10, Lucinda Philip placed an order for a large pepperoni pizza (PieNum = 1) and a small garlic pizza (PieNum = 2). On November 10, Yu-Ran Chen ordered a large plain pizza (with no toppings). Note that the PieNum field is only unique within a given order; thus, the first (and only) pizza in this order also has PieNum = 1. On November 10, Mohan Singh ordered a large mushroom and peppers pizza (two toppings on the same pizza, with PieNum = 1), along with a large artichoke hearts pizza (PieNum = 2). For this order, note that the lines with MUSH and PEP both have attribute PieNum equal to 1, meaning they are both for the first pizza in the order. On November 11, William Hurd ordered a small sausage, mushroom, and garlic pizza (three toppings on the same pizza - again note there are multiple lines with the same value for PieNum), and a large plain pizza. On November 12, Lucinda Philip placed another order, this time for three pizzas: a large sausage, a large extra cheese, and a small garlic. You should assume that a zip code table is not available.

Explanation / Answer

ToppingDescrip

It is not needed to have topping description repeated with every order row, so a topping table can be seperated as above.

  

One row for every pie

A new key field is added

If a pie has a topping, then the information is stored in this table.

If there are 3 toppings in a pie, there will be 3 rows here maintaing reference to the OrderDetKey to know for which pie it is..

This is now normalized pizza orders database. Additionally to get a better understanding, you can put the given data into these tables. Then you can clearly see how repeatation of information that is not needed e.g. custid with every row of pie and topping is avoided. For 1 order only once custid is saved in order header.

Similarly for all other fields, the database is normalized.

1. Topping_Table ToppingCode

ToppingDescrip

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.