The E-R model is expressed in terms of: (i) Entities (ii) Relationships among…

2004

The E-R model is expressed in terms of:

  • (i) Entities

  • (ii) Relationships among entities

  • (iii) Attributes of entities

Which of the following combinations is correct?

Answer: B. (i), (ii) and (iii)Concept An Entity-Relationship model describes a domain through entity sets, the relationships that associate those entity sets, and attributes that record…

  1. A.

    (i) and (iii)

  2. B.

    (i), (ii) and (iii)

  3. C.

    (ii) and (iii)

  4. D.

    None of the above

Attempted by 1098 students.

Show answer & explanation

Correct answer: B

Concept

An Entity-Relationship model describes a domain through entity sets, the relationships that associate those entity sets, and attributes that record properties of entities or relationships.

These three construct families answer three different modeling questions: what exists, how the modeled objects are connected, and what descriptive data is stored about them.

Application

In the stem, (i) supplies the modeled objects, (ii) supplies their associations, and (iii) supplies their descriptive properties. Together, (i), (ii), and (iii) cover the E-R model vocabulary named by the definition.

Contrast

  • The combination (i) and (iii) describes objects and their properties but omits the association construct.

  • The combination (ii) and (iii) describes associations and properties but omits the object sets that participate in those associations.

  • None of the above would apply only if every listed combination failed to cover the required construct families; one listed combination does cover them.

Therefore, the correct combination is (i), (ii), and (iii).

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Tpsc Assistant Technical Officer

Loading lesson…