Question
Convert the following to BCNF 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
Convert the following to BCNF
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: _
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started