Which business rules can be associated with the attached ER diagram? (Multi-sele

Question

Which business rules can be associated with the attached ER diagram? (Multi-select)

Question 2 options:

Each and every brand is produced by only one manufacturer.

For each brand, the brand name and brand level are kept in the system.

Every model is produced as part of a brand.

Every brand has one or more models

Each and every brand is produced by only one manufacturer.

For each brand, the brand name and brand level are kept in the system.

Every model is produced as part of a brand.

Every brand has one or more models

MODEL MANUFACTURER PK Model Num BRAND Model Jets Model Motors Man Name Man Street Man City Man State Man ZIPCode Man AreaCode Man Phone Man AccNum makes PK Brand ID includes Model_HP Model _MSRP Model_HWPrice Model_Weight Model_WCapacity Model Seats Brand Name Brand Level 8

Explanation / Answer

Looking at the above ER Diagram I find that 2 of the above 4 options are true:-

For each brand, the brand name and brand level are kept in the system - The ER Diagram depicts that Brand table contains Brand_Name and Brand_Level. So this is surely true.

Every model is produced as part of a brand - This is also true as every model should have a brand for it and without a brand a model cannot exist as per the above ER Diagram.

Each and every brand is produced by only one manufacturer - It is not necessary that one manufaturer will produce each and every brand. Multiple manufaturers may produce multiple brands.

Every brand has one or more models - One brand may not have even 1 model. So it is not that minimum 1 model must exist for one brand.

So the answer will be, Option B and C are true.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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