Question: Create/Make a EERD Diagram based off the information given in the screenshot and make it according to what is being asked. Make sure to also

A manufacturing company produces products. The following product information is stored: product

Create/Make a EERD Diagram based off the information given in the screenshot and make it according to what is being asked. Make sure to also include showing the entities, primary keys, attributes for each entity, and crows feet/relationships. Please use MySQL  for this and also Include the screen of the EERD diagram on MySQL

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. Create an EERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Submit a screenshot in docx, pdf, doc file format of your EERD showing the entities, primary keys, attributes for each entity, and crows feet/relationships. 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!