Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 1- Draw an entity relationship diagram (ERD) for the following situations: 1. A manufacturing company produces products. The following product information is stored: product

Task 1- Draw an entity relationship diagram (ERD) for the following situations: 1. 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. Use Figure B.1 for this exercise. Assumptions 1. A supplier can exist without providing components. 2. A component does not have to be associated with a supplier. 3. 4. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components. ERD

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

The Effective Controller In The 21st Century Accounting Strategies For Business Management

Authors: Yanyong Thammatucharee

1st Edition

1439217424, 978-1439217429

More Books

Students also viewed these Accounting questions

Question

4. What decision would you make and why?

Answered: 1 week ago