Entity Relationship Diagramming (Please create a diagram in draw.io)

A manufacturing company produces products. The following product information is stored: product name, product ID (primary key) and quantity on hand. These products are made up of many components and components are in many products. Each component can be supplied by one and only one supplier. Suppliers can supply zero to many components to the company. The following component information is kept: component ID, name, description, suppliers who supply them as a foreign key, and products in which they are used. For suppliers, we keep SupplierID, Name, Address, and email.

Entity Relationship Diagramming with Draw.IO Directions: Analyze the problem and develop a diagram using draw.io. You may want to sketch the diagram using paper and pencil first! The database description that you are diagramming: A manufacturing company produces products. The following product information is stored: product name, product ID (primary key) and quantity on hand. These products are made up of many components and components are in many products. Each component can be supplied by one and only one supplier. Suppliers can supply zero to many components to the company. The following component information is kept component ID, name, description, suppliers who supply them as a foreign key, and products in which they are used. For suppliers, we keep SupplierID, Name, Address, and email. Create an ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, and relationships between the entities. The many to many relationship between products and components needs a table often called a "linking" table. This table needs a primary key of productid and supplierid. HINT: You need the following entities: Product, Component, Components_in_Product, Supplier. Components_in_Product is in between Product and Component and breaks up the many to many relationship Product has product name, product ID (primary key) and quantity on hand as attributes. Component has Component ID (primary key), name, description, SupplieriD (this is a foreign key to supplier). Components_in_Product has product ID, Component ID (composite Primary key - the two together make it unique and each one individually is a foreign key), and Quantity (this is the quantity that goes in the product for example a chair might have 4 legs). Supplier has SupplierID (primary key), Name, Address, and email. 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. HOW TO START Remember, create this in Draw.10 and turn in your diagram saved as a PNG file. Start by creating the four entities and adding the attributes, then build the relationships and cardinality, Good luck! You need to turn in the assignment individually - you can ask each other for help but this does not mean getting the file from another person of course. You will have a question on the exam that relates to diagramming. Be sure to contact Dr. Thompson for help and/or attend office hours