QUESTION 3 Open with Google Docs Question a), b), c) and d) are based on the following table: Table Name: Invoice 12 OrderID Order Date CustID CustName CustAdd Prold ProDesc ProFinish ProPrice OrderQuan 1121 15/11/2020 212 Jati Corp Kuantan, Bookcase Stained 350 1 Pahang Oak 25 Computer Table Black 195 3 36 Swivel Chair White 130 2 1130 25/11/2020 220 Modern Kuching 21 Dining Table Set Cherry 1500 1 Furnish Sarawak 36 Swivel Chair White 130 4 Note: CustID - Customer ID; CustName - Customer Name; CustAdd - Customer Address; ProID - Product ID; ProDesc - Product Description; ProFinish - Product Finish; ProPrice - Product Price; OrderQuan - Order Quantity NW a) Convert the above table to a 1NF table. (1 marks) b) Draw the 1NF dependency diagram and show the all the partial and transitive dependencies that exist. (4 marks) c) Identify THREE (3) anomalies that can exist in the table that you have answered in (a), explain your answers with examples taken from the data in the table. (6 marks) d) Normalize the table into 3NF. Show all the steps on how you arrive at your answer. (6 marks) QUESTION 3 Open with Google Docs Question a), b), c) and d) are based on the following table: Table Name: Invoice 12 OrderID Order Date CustID CustName CustAdd Prold ProDesc ProFinish ProPrice OrderQuan 1121 15/11/2020 212 Jati Corp Kuantan, Bookcase Stained 350 1 Pahang Oak 25 Computer Table Black 195 3 36 Swivel Chair White 130 2 1130 25/11/2020 220 Modern Kuching 21 Dining Table Set Cherry 1500 1 Furnish Sarawak 36 Swivel Chair White 130 4 Note: CustID - Customer ID; CustName - Customer Name; CustAdd - Customer Address; ProID - Product ID; ProDesc - Product Description; ProFinish - Product Finish; ProPrice - Product Price; OrderQuan - Order Quantity NW a) Convert the above table to a 1NF table. (1 marks) b) Draw the 1NF dependency diagram and show the all the partial and transitive dependencies that exist. (4 marks) c) Identify THREE (3) anomalies that can exist in the table that you have answered in (a), explain your answers with examples taken from the data in the table. (6 marks) d) Normalize the table into 3NF. Show all the steps on how you arrive at your answer. (6 marks)