Question: with out table just column names Given the Customer_Orders table that shows the details of orders that ordered by customers, the product included in each
Given the Customer_Orders table that shows the details of orders that ordered by customers, the product included in each order, answer the below questions Customer_Orders Table CustName Order OrderDate ProdcutName price Supplier D SupName Khalid 1111 1-1-2017 Coffee 10 10 All Cafe Khalid 1111 1-1-2017 Eggs 5 20 Watani Khalid 2222 1-1-2017 Coffee 10 10 AliCafe Amal 3333 1-1-2017 Milk 15 10 AliCafe Abdullah 4444 5-12-2019 Coffee 10 10 AliCafe Abdullah 4444 5-12-2019 Milk 15 10 AliCafe 1) Identity All functional dependencies FD's for Customer_Orders Table (3.5) 2) Apply the normalization rule based on the (FDs) to make the following table in 3NF, then re-design the table based on this FDs. (5) 3) Explain by example what's the problem if the table above doesn't achieve 2NF. (1.5) For the toolbar, Dress ALT+F 10 (PC) ALT.FNF10 (Mac) Arial 3 [12 T.EE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
