The table below contains repeating groups and multivalued attributes. Order_ID Order_Date Cust_ID Cust_Name Cust_Loc Pro

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

The table below contains repeating groups and multivalued attributes. Order_ID Order_Date Cust_ID Cust_Name Cust_Loc Pro

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply