Question
Consider that at an organization manufacturing furniture, each product described by Product No., Description, and Cost. Each product is comprised of at least three components
Consider that at an organization manufacturing furniture, each product described by Product No., Description, and Cost. Each product is comprised of at least three components described by Component No., Description, a Unit of Measure and components are used to make one or many products (that is, must be used in at least one product). In addition, assume that components are used to make other components that raw materials are also considered to be components. In both cases of components being used to make other components, it is also required to keep track of how many components go into making something else. DRAW an Entity Relationship diagram (ERD) for this situation and place minimum and maximum cardinalities on the diagram. Normalize your ERD to the level that removes redundancies. Add assumptions if required.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started