Exercise #2 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: • All DDL statements All DML statements to query, insert and update all tables All needed constraints