Question: just column names Given the Customer_Orders table that shows the details of orders that ordered by customers, the product included in each order, answer the
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 OrderiD Order Date ProdcutName price Supplier D SupName Khalid 1111 1-1-2017 Coffee 10 10 AliCafe Khalid 1111 1-1-2017 Eggs 5 20 Watani Khalid 2222 1-1-2017 Coffee 10 10 AliCafe Amal 3333 1-1-2017 MIIK 15 10 AliCafe Abdullah 4444 5-12-2019 Coffee 10 10 AllCafe Abdullah 4444 5-12-2019 Milk 15 10 Alicafe 1) Identify 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, press ALT+F10 (PC) or ALT+FNF 10 (Mac) TArial 3112011
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
