Question: Transform the following to first normal form (1nf) and second normal form (2nf) Customer Address Name Cell 1551 E Main Street Corrie 1511551 22 N
Transform the following to first normal form (1nf) and second normal form (2nf)
| Customer | ||
| Address | Name | Cell |
| 1551 E Main Street | Corrie | 1511551 |
| 22 N 2nd Place | Jenny | 8675309 |
| 1551 E Main Street | Joseph | 5155115 |
| 4848 W 48th Terrace | Stephen | 8884444 |
| 342 S Spring Way | Vikki | 3333342 |
FDs: { } { , h_ }Key:
| Driver | |||
| Car_Number | Name | Make | Model |
| 1 | Bill | Honda | Civic |
| 2 | Charlie | Ford | Escort |
| 3 | Linda | Ford | Taurus |
| 4 | Nathan | Subaru | Outback
|
FDs: { _ } { , } { } { }
Key: _,
| Order | |||
| Driver | Is_Delivery | Order_ID | Pizza_ID |
| Bill | TRUE | 1 | 4 |
| Linda | TRUE | 2 | 1 |
| NULL | FALSE | 3 | 7 |
| Bill | TRUE | 4 | 1 |
FDs: { _ } { , , _}Key: _
| Pizza | |||||||||
| Name | Crust | Cheese | Pizza_ID | Price | Size | Sauce | Topping_1 | Topping_2 | Topping_3 |
| Big Cheese | thick | mozzarella | 1 | 9.50 | large | red | NULL | NULL | NULL |
| Big Cheese | thin | mozzarella | 2 | 8.50 | large | red | NULL | NULL | NULL |
| Cheese Just Right | thick | mozzarella | 3 | 7.50 | medium | red | NULL | NULL | NULL |
| Cheese Just Right | thin | mozzarella | 4 | 6.50 | medium | red | NULL | NULL | NULL |
| Lil Cheese | thick | mozzarella | 5 | 6.00 | small | red | NULL | NULL | NULL |
| Lil Cheese | thin | mozzarella | 6 | 5.00 | small | red | NULL | NULL | NULL |
| Mushroom n Pep | thick | mozzarella | 7 | 12.50 | large | red | mushroom | pepperoni | NULL |
| Hawaiian | thin | mozzarella | 8 | 12.00 | large | red | ham | pineapple | NULL |
| Meatballa | thin | fontina | 9 | 11.00 | medium | white | meatball | NULL | NULL |
| Popeye's Delight | thin | fontina | 10 | 11.00 | medium | white | chicken | garlic | Spinach |
| Popeye's Delight | thin | fontina | 11 | 12.00 | large | red | chicken | garlic | Spinach |
| Popeye's Delight | thin | mozzarella | 12 | 11.75 | large | red | chicken | garlic | Spinach |
| Veggie | thin | none | 13 | 6.50 | small | red | onion | pepper | NULL |
FDs: _ {, , h, , } ,,h, {} {_1,_2,_3}
Key: {_}
| Restaurant | ||
| Address | Name | Phone_Number |
| Gainesville | Panucci's Pizza | 3523000 |
| Old New York | Panucci's Pizza | 2123000 |
| Mystic, Connecticut | Mystic Pizza | 2011988 |
| Tri-County, USA | Pizza Planet | 4328765 |
Key: ,
{ , } { h_ }
| Topping | ||
| Calories | Food_Group | Name |
| 175 | meat | chicken |
| 20 | seasoning | garlic |
| 225 | meat | ham |
| 300 | meat | meatball |
| 15 | veggie | mushroom |
| 30 | veggie | onion |
| 40 | veggie | pepper |
| 250 | meat | pepperoni |
| 50 | fruit | pineapple |
| 10 | veggie | spinach |
Key:
{ } { , _ }
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
