Draw the ERD for the following scenario. . A manufacturing company produces products. The following product information

Draw the ERD for the following scenario.

 

Transcribed Image Text:

. A manufacturing company produces products. The following product information is stored: product name, identifier product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. For supplier the system kept supplier id unique, supplier name, contact and supplied items. A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components. I . A manufacturing company produces products. The following product information is stored: product name, identifier product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. For supplier the system kept supplier id unique, supplier name, contact and supplied items. A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components. I

Answer rating: 100% (QA)

Answer ERD ERD ERD is the entity relationship diagram In this all the three are inter rel... View the full answer