1. [25 pts] Using the functional dependencies identified here [note these are based upon the solution to Hw #6 but also include additional specifics not required by Hw #6], transform the following relationships into 1NF, 2NF, and BCNF. Make the changes one at a time, clearly showing the step- by-step transformation of the relations at each stage. In other words, transform the relations into 1NF first. Then, transform the relations into 2NF. Finally, transform the relations into BCNF. Customer Name Address 551 E Main StreetCorrie 22 N 2hd Place 1551 E Main Street Joseph 5155115 4848 W 48th Terrace Stephen 8884444 342 S Spring Wa Cell 1511551 8675309 Jenny Vikki 3333342 FDs: {Name ) -+{Address, Phone _Number) Key: {Name) Driver Car Number Name Make Model 1 Bill Charlie Ford Linda Nathan Subaru Outback Honda Civic Escort Taurus Ford 4 FDs: {Car _Number) -{Name, Model ) {Model) Make} Key: {Car Number, Model) Order DriverIs Delive Bill Linda TRUE NULLFALSE Bill rder ID Pizza ID TRUE 1 7 1 TRUE 4 FDs {Order-ID} { Driver, ls Delivery, Pizza-ID) Key: Order_ID) Pizza Crust Cheese thick mozzarella 1 thin mozzarella 2 Pizza ID Price Size Sauce Topping_1 Topping 2 Topping 3 red NULL red NULL Name Big Cheese Big Cheese Cheese Just Right thick mozzarella 3 Cheese Just Right thin mozzarella 4 Lil Cheese Lil Cheese Mushroom n Pep thick mozzarella7 Hawaiian Meatballa Popeye's Delightthinfontina Popeye's Delightthin fontina Popeye's Delightthinmozzarella 12 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 9.50 large 8.50 arge 7.50 medium red NUL 6.50 medium redNULL 6.00 smallred NULL 5.00 smallredNULL 12.50 large 2.00 large 11.00 medium whitemeatba NULL 11.00 medium whitechickern 12.00 large 11.75 large 6.50 smallredonion thick mozzarella 5 thin mozzarella 6 red mushroom red ham roni NULL thin mozzarella 8 thin fontina ineapple NULL arlic arlic arlic NULL Spinach Spinach Spinach NULL 10 red chicken e red chicken hin none 13 FDs: [PizzaIDName, Crust, Cheese, Size, Sauce) Name, Crust, Cheese, Size) -Price) Name) - Topping 1,Topping 2,Topping.3) Key: [PizzaID] What will do in the case where we include the Name: "Build Your Own" [BYO] to our list of pizzas? We will not deal with BYO on this assignment. However, start thinking about the implications this has on our DB and how you would resolve this inside the DB representation. Restaurant Address Gainesville Old New York Mystic, Connecticut Phone Numbe 3523000 2123000 2011988 Name Panucci's Pizza Panucci's Pizza Mystic Pizza Tri-County, USA Pizza Planet 4328765 Required: {Name, Address ) -> {Phone Number) Key: (Name, Address) Toppin Calories Food Group Name 175 20 225 300 15 30 40 250 50 10 chicken meat seasonin meat meat arlic ham meatball mushroom onion meat fruit veggie pepperoni pineapple spinach Required: {Name ){Calories, Food Group} Key: {Name) 1. [25 pts] Using the functional dependencies identified here [note these are based upon the solution to Hw #6 but also include additional specifics not required by Hw #6], transform the following relationships into 1NF, 2NF, and BCNF. Make the changes one at a time, clearly showing the step- by-step transformation of the relations at each stage. In other words, transform the relations into 1NF first. Then, transform the relations into 2NF. Finally, transform the relations into BCNF. Customer Name Address 551 E Main StreetCorrie 22 N 2hd Place 1551 E Main Street Joseph 5155115 4848 W 48th Terrace Stephen 8884444 342 S Spring Wa Cell 1511551 8675309 Jenny Vikki 3333342 FDs: {Name ) -+{Address, Phone _Number) Key: {Name) Driver Car Number Name Make Model 1 Bill Charlie Ford Linda Nathan Subaru Outback Honda Civic Escort Taurus Ford 4 FDs: {Car _Number) -{Name, Model ) {Model) Make} Key: {Car Number, Model) Order DriverIs Delive Bill Linda TRUE NULLFALSE Bill rder ID Pizza ID TRUE 1 7 1 TRUE 4 FDs {Order-ID} { Driver, ls Delivery, Pizza-ID) Key: Order_ID) Pizza Crust Cheese thick mozzarella 1 thin mozzarella 2 Pizza ID Price Size Sauce Topping_1 Topping 2 Topping 3 red NULL red NULL Name Big Cheese Big Cheese Cheese Just Right thick mozzarella 3 Cheese Just Right thin mozzarella 4 Lil Cheese Lil Cheese Mushroom n Pep thick mozzarella7 Hawaiian Meatballa Popeye's Delightthinfontina Popeye's Delightthin fontina Popeye's Delightthinmozzarella 12 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 9.50 large 8.50 arge 7.50 medium red NUL 6.50 medium redNULL 6.00 smallred NULL 5.00 smallredNULL 12.50 large 2.00 large 11.00 medium whitemeatba NULL 11.00 medium whitechickern 12.00 large 11.75 large 6.50 smallredonion thick mozzarella 5 thin mozzarella 6 red mushroom red ham roni NULL thin mozzarella 8 thin fontina ineapple NULL arlic arlic arlic NULL Spinach Spinach Spinach NULL 10 red chicken e red chicken hin none 13 FDs: [PizzaIDName, Crust, Cheese, Size, Sauce) Name, Crust, Cheese, Size) -Price) Name) - Topping 1,Topping 2,Topping.3) Key: [PizzaID] What will do in the case where we include the Name: "Build Your Own" [BYO] to our list of pizzas? We will not deal with BYO on this assignment. However, start thinking about the implications this has on our DB and how you would resolve this inside the DB representation. Restaurant Address Gainesville Old New York Mystic, Connecticut Phone Numbe 3523000 2123000 2011988 Name Panucci's Pizza Panucci's Pizza Mystic Pizza Tri-County, USA Pizza Planet 4328765 Required: {Name, Address ) -> {Phone Number) Key: (Name, Address) Toppin Calories Food Group Name 175 20 225 300 15 30 40 250 50 10 chicken meat seasonin meat meat arlic ham meatball mushroom onion meat fruit veggie pepperoni pineapple spinach Required: {Name ){Calories, Food Group} Key: {Name)