Problem: Could you please draw the ER diagram using MYSQL?
MYSQL ER diagram
Case Description: Manufacturing Company Database System Project
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. Other information includes suppliers who supply them and (multiple) factory warehouses where products are stored.
Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality.
Assumptions
- A supplier can provide many components, but exist without providing components.
- A component does not have to be associated with a supplier.
- A component can be used in many products but may not be associated with a product.
- A product cannot exist without components.