Question: Please solve part 2 as well, it depends on part 1. 1. 20 pts] Given these relations and the corresponding data, identify the functional dependencies.

![1. 20 pts] Given these relations and the corresponding data, identify the](https://s3.amazonaws.com/si.experts.images/answers/2024/09/66d70cb2ec3eb_52266d70cb28ab84.jpg)
Please solve part 2 as well, it depends on part 1.
1. 20 pts] Given these relations and the corresponding data, identify the functional dependencies. Clearly specify all functional dependencies, showing the functional determining (set on the left side) and functionally determined (set on the right side)attributes. The functional dependencies identified must provide closure over the entire relation for every relation 2. 5 pts] What is missing from the DB that we have constructed using this set of relations? Is there anything that we have not represented or associated? Customer Name Address 1551 E Main Street Corrie 22 N 2nd Place Phone Number 1511551 8675309 1551 E Main Street Joseph 5155115 4848 W 48th Terrace Stephen 8884444 3333342 Jenn 42 S Spring Way Vikki Driver Car Number Name Make Model Bill Charlie Ford Linda Nathan Subaru Outback Honda Civic Escort Taurus Ford Order Driver Is_Delivery Order ID Pizza ID Bill TRUE Linda TRUE NULL FALSE Bill TRUE Pizza Crust Cheese thickmozzarella1 thickmozzarella2 thickmozzarella 3 thickmozzarella 4 Pizza ID Price Size Sauce Topping 1 Topping 2 Topping 3 NULL NULL NULL NULL NULL NULL mushroom NULL NULL NULL eroni NULL ineapple NULL NULL 9.50 large medium red small mozzarella 5 fontina fontina none 6.00 sm 12.50 large 12.00 lar 11.00medium white meatball NULL 11.00medium white chicken spinach small onion NULL Restaurant Name Panucci's Pizza Addres:s Old New York Mystic, Connecticut Tri-County, USA Phone_Number 3523000 2011988 4328765 2 Pizza Planet Topping 8 Calories Food Grou Name chicken 175 meat seasonin meat meat 225 meatball mushroom onion veggie meat ineapple spinach
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
