A component product or products on be used to make other finished products. For

Question

A component product or products on be used to make other finished products. For example, a component product like wheels can be used to make different types of bicycles - 20 inch wheels could be used to make a men's bicycle or a woman's bicycle. Also a combination of products could be used to make a product For example the combination of 20 spokes, one 20 inch rim, one inner tube, and one outer tube can be combined to make a 20 inch wheel Some products are not used to make other products. For example, a finished bicycle isn't used to make any other product We even have some products that are not composed of other products. For example, the bicycle wheel spokes arc purchased and not composed of other parts. Which of the following ERDs would best represent this relationship? We want to track people and their relatives. Everyone has a relative - at least a mom while some people have a bunch of relatives such as brother, sisters, and cousins. To represent this, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below. (The first symbol in the answer replaces the 1 in the ERD and the second symbol in the answer replaces the 2 in the ERD.) many and 0 0 and many 1 and 1 0 and 1 many and 1 1 and 0 1 and many and many

Explanation / Answer

Answer to first question is diagram 1

Circle means optional, and single vertical line means mandatry; 3 tilted lines means many

Since some products are not used to make the products and there are some products which are not composed of other products => it means relationship is optional. Since a product can be used to make different products and a product can be composed of multiple products => it means relationship is many, hence the first diagram.

Answer to second question is many-to-many

Since one person can have many relatives (brother, sister etc.) and two and more person can have same relative hence the relationship criteria is many-to-many

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.