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 2. Create an ERDfor the fully normalized tables at (1) above. All details about thetype of relationships and the keys should be represented.