Answered step by step
Verified Expert Solution
Link Copied!

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 (i.e., 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 E-R 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 E-R diagram from part a into a set of 3NF relations.
Please show the diagram with full explanations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Michael V. Mannino

4th Edition

0615231047, 978-0615231044

More Books

Students also viewed these Databases questions