The E-R model is expressed in terms of which of the following? I. Entities II.…
2009
The E-R model is expressed in terms of which of the following?
I. Entities
II. Relationships among entities
III. Attributes of entities
IV. Functional relationship
Answer: D. I,II,III — ConceptA conceptual data model represents the kinds of objects in a domain, the properties used to describe those objects, and the associations that connect…
- A.
I,II
- B.
I,II,IV
- C.
II,II,IV
- D.
I,II,III
Attempted by 1056 students.
Show answer & explanation
Correct answer: D
Concept
A conceptual data model represents the kinds of objects in a domain, the properties used to describe those objects, and the associations that connect them. In the E-R model, these ideas are represented by entities, attributes, and relationships.
Application
Statement I names entities, which represent distinguishable object types in the modeled domain.
Statement II names relationships, which represent associations among entity types.
Statement III names attributes, which record descriptive properties of entities or relationships.
Statement IV uses the phrase functional relationship; this is a constraint or mapping description rather than a separate basic construct of the E-R model.
Contrast
I, II omits the descriptive properties represented by attributes.
I, II, IV substitutes a constraint-oriented phrase for attributes.
II, II, IV repeats relationships and omits both entities and attributes.
I, II, III contains the three basic constructs used to express an E-R model.
Result
Therefore, the applicable statements are I, II, and III.
A video solution is available for this question — log in and enroll to watch it.