A company produces widgets. The following widget information is stored: product name, 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.

The database schema below shows the tables and columns needed for this database. The database will contain the following five tables. Table names are bolded and column names are in the parentheses.

Component(CompID, CompName, Description) PK=CompID

Product(ProdID, ProdName, QtyOnHand) PK=ProdID

Supplier(SuppID, SuppName) PK = SuppID

CompSupp(CompID, SuppID) PK = CompID, SuppID

Build(CompID, ProdID, QtyOfComp) PK= CompID, ProdID

Relational Assumptions

• 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.

Create an ERD to represent this database. Specifically, you are being asked show the relationships between the tables above with the appropriate cardinality in your ERD.

Answer rating: 100% (QA)

Heres the description of the relationships and cardinalities for the given tables The Component tabl... View the full answer