Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Graph Databases

Authors: Ian Robinson, Jim Webber, Emil Eifrem

1st Edition

1449356265, 978-1449356262

More Books

Students also viewed these Databases questions

Question

What contributions or services will you provide to others?

Answered: 1 week ago