Scenario: A customer places an order of the items he/she has to buy. One customer can buy more than one item and more than one quantity. The unit price of each item is also stored in database so that we can calculate the total cost of each item ordered. When customer places order his/her name and address is also stored and each customer is given a unique account number. The table of this scenario is in separate sheet. The table (shown in a separate sheet) is not normalized. 8 points Normalize to 1st Normal Form (no need to add values to each cell just write columns name and explain why the given table is not in 1st Normal Form) Identify all the Candidate Keys. Identify all the possible Functional dependenciesScenario: A customer places an order of the items he/she has to buy. One customer can buy more than one item and more than one quantity. The unit price of each item is also stored in database so that we can calculate the total cost of each item ordered. When customer places order his/her name and address is also stored and each customer is given a unique account number. The table of this scenario is in separate sheet. The table (shown in a separate sheet) is not normalized. 8 points Normalize to 1st Normal Form (no need to add values to each cell just write columns name and explain why the given table is not in 1st Normal Form) Identify all the Candidate Keys. Identify all the possible Functional dependenciesScenario: A customer places an order of the items he/she has to buy. One customer can buy more than one item and more than one quantity. The unit price of each item is also stored in database so that we can calculate the total cost of each item ordered. When customer places order his/her name and address is also stored and each customer is given a unique account number. The table of this scenario is in separate sheet. The table (shown in a separate sheet) is not normalized. 8 points Normalize to 1st Normal Form (no need to add values to each cell just write columns name and explain why the given table is not in 1st Normal Form) Identify all the Candidate Keys. Identify all the possible Functional dependenciesScenario: A customer places an order of the items he/she has to buy. One customer can buy more than one item and more than one quantity. The unit price of each item is also stored in database so that we can calculate the total cost of each item ordered. When customer places order his/her name and address is also stored and each customer is given a unique account number. The table of this scenario is in separate sheet. The table (shown in a separate sheet) is not normalized. 8 points Normalize to 1st Normal Form (no need to add values to each cell just write columns name and explain why the given table is not in 1st Normal Form) Identify all the Candidate Keys. Identify all the possible Functional dependenciesScenario: A customer places an order of the items he/she has to buy. One customer can buy more than one item and more than one quantity. The unit price of each item is also stored in database so that we can calculate the total cost of each item ordered. When customer places order his/her name and address is also stored and each customer is given a unique account number. The table of this scenario is in separate sheet. The table (shown in a separate sheet) is not normalized. 8 points Normalize to 1st Normal Form (no need to add values to each cell just write columns name and explain why the given table is not in 1st Normal Form) Identify all the Candidate Keys. Identify all the possible Functional dependencies

+ Order no. Item price Acc no. 178 Customer Daisy's Cafe Address 27 Bay Drive, Cove Date 167 Item Bakewell Tart 7823 Qty. 20 Total cost 12.35 0.15 Danish Pastry Apple Pie 13 45 120 0.20 0.15 0.20 4633 526 Smiths 16/7 Butteries 24.00 12 Dee View, Aberdeen 3 High Street, Banchor 2276 167 Sally's Snacks 1777 Apple Pie 130 0.15 56.50 0.18 0.50 Cherry Pie Steak Pie Meringue Pie Apple Pie 100 30 20 15 0.20 1788 032 Tasty Bite 18/7 0.15 7.50 17 Wood Place, Insch Danish Pastry 50 0.20 + Order no. Item price Acc no. 178 Customer Daisy's Cafe Address 27 Bay Drive, Cove Date 167 Item Bakewell Tart 7823 Qty. 20 Total cost 12.35 0.15 Danish Pastry Apple Pie 13 45 120 0.20 0.15 0.20 4633 526 Smiths 16/7 Butteries 24.00 12 Dee View, Aberdeen 3 High Street, Banchor 2276 167 Sally's Snacks 1777 Apple Pie 130 0.15 56.50 0.18 0.50 Cherry Pie Steak Pie Meringue Pie Apple Pie 100 30 20 15 0.20 1788 032 Tasty Bite 18/7 0.15 7.50 17 Wood Place, Insch Danish Pastry 50 0.20