Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assume that at IBM each product ( described by Product No . , Description, and Cost ) is composed of at least three components (
Assume that at IBM each product described by Product No Description, and Cost is composed of at least three components described by Component No Description, and Unit of Measure and components are used to make one or many products ie must be used in at least one product In addition, assume that components are used to make other components and that raw materials are also considered to be components. In both cases of components being used to make products and components being used to make other components, we need to keep track of how many components go into making something else.
a Draw an ER diagram using Crows foot notation for this situation and place minimum and maximum cardinalities on the diagram. IMPORTANT the DIAGRAM is WELL DONE
b Transform the ER diagram from part a into a set of NF relations.
Please show the diagram with full explanations
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