Question

A manufacturing company produces products. The following product 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. Show table names, primary keys, attributes for each table, relationships between the entities including all constrains required.

Assumptions in your database design:

• A supplier can exist without providing components.

• A component must be associated with a supplier.

• A component must be associated with a product.

• A product cannot exist without components.

Design your database and implement it by providing all the required DDL and DML SQL statement to create the needed database objects and populate the tables with data. Make sure you included all required constraints and appropriates column datatypes.

Submit:

Write the sql code for creating these tables (the DDL statements).

Write query and update DML in SQL that must contain a where condition.

INSERT must populate all columns

Provide at least three statements for each type of DML • All needed constraints. Make sure you name all your constraints.

Answer 1