This figure shows the relationships in an assembly line among three entities such as employees, components and products.$1.$ Convert the relationships among entities to relations$($tables$)$$2.$ Explain how you created the relations

Transcribed Image Text:

This figure shows the relationships in an assembly line among three entities such as employees, components and products. 1. Convert the relationships among entities to relations (tables) 2. Explain how you created the relations CompID 563 872 882 883 888 Component ComplD Туре Name Type W32 M15 H32 H33 T54 Name Wheel Mirror Door hinge Trunk hinge Trunk handle 1 Employee EmployeelD Name 1 Due date: 01:00PM, Jan. 11, 2024 * Assembly EmployeeID 11 12 ProductID A3222 A5411 1 11 11 11 11 12 EmployeeID 12 12 12 Type Name Name Joe Jones Maria Rio Product ProductID Туре X32 B17 CompID 563 872 563 872 563 882 888 883 Name Corvette Camaro ProductID A3222 A3222 A5411 A5411 A3222 A3222 A3222 A5411 This figure shows the relationships in an assembly line among three entities such as employees, components and products. 1. Convert the relationships among entities to relations (tables) 2. Explain how you created the relations CompID 563 872 882 883 888 Component ComplD Туре Name Type W32 M15 H32 H33 T54 Name Wheel Mirror Door hinge Trunk hinge Trunk handle 1 Employee EmployeelD Name 1 Due date: 01:00PM, Jan. 11, 2024 * Assembly EmployeeID 11 12 ProductID A3222 A5411 1 11 11 11 11 12 EmployeeID 12 12 12 Type Name Name Joe Jones Maria Rio Product ProductID Туре X32 B17 CompID 563 872 563 872 563 882 888 883 Name Corvette Camaro ProductID A3222 A3222 A5411 A5411 A3222 A3222 A3222 A5411

Answer rating: 100% (QA)

Based on the provided diagram we can see that there are three entities Employee Component and Product which are involved in an assembly process This a... View the full answer