The table below contains repeating groups and multivalued attributes. Order_ID Order_Date Cust_ID Cust_Name Cust_Loc Pro
Posted: Tue Jul 12, 2022 8:05 am
The table below contains repeating groups and multivaluedattributes. Order_ID Order_Date Cust_ID Cust_Name Cust_Loc Prod_IDProd_Desc Prod_Price Qty_Sold 1031 20/06/22 C0045 ABC Ltd SpanishTown P00101 P00025 P00150 Dell Laptop Computer Desk Desk Lamp150,000 45,000 2,500 3 5 5 1012 21/06/22 C0021 Learners Haven MayPen P02050 P00220 Projector Tablet 112,000 500 2 10 Description ofFields: Order_ID = unique ID assigned to each order; Order_Date =date the order was placed; Cust_ID = unique ID assigned to eachcustomer; Cust_Name = name of customer; Cust_Loc = city location ofthe customer; Prod_ID = unique ID assigned to each product;Prod_Desc = description of the product; Prod_Price = price of theproduct; Qty_Sold = quantity of the product sold 1. Normalize theabove table to 3NF. Show the resulting table(s) after eachnormalization step (i.e., 1NF, 2NF & 3NF). Label thenormalization steps and use appropriately descriptive names for thetables.