Exercise 3 Manufacturer 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 ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. 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. List of Entities and the Attributes List of Relationship and Cardinalities
Exercise 3
Manufacturer
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 ERD to show how you would track this information.
Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality.
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.
-
List of Entities and the Attributes
-
List of Relationship and Cardinalities
-
Draw the Conceptual Model
-
Draw the Logical Model with exhaustive attributes as well as the constraints (Primary Key and Foreign Key).
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 1 images
