DATA-MANAGEMENT-FOUNDATIONS practice question 4 of 15

Which object relates an entity to itself in an entity-relationship model?

Full set: 60 questions

Domain Data Modeling

Answer options
A: Repository
B: Relationship instance
C: Reflexive relationship Correct answer
D: Attribute
Correct Answer:
C. Reflexive relationship
Explanation

A reflexive relationship, also known as a unary or recursive relationship, occurs when an entity type has a relationship with itself. In this structure, instances of the same entity set participate in the relationship in different roles. A classic example is an 'Employee' entity where one employee instance (in the role of 'manager') supervises another employee instance (in the role of 'subordinate'). Both the manager and the subordinate are drawn from the same 'Employee' entity set, thus relating the entity to itself.

Why Incorrect

A. Repository: A repository is a central storage location for data; it is not a component used to model relationships within an ER diagram.
B. Relationship instance: This is a specific association between entity instances, not the structural type of relationship that connects an entity to itself.
D. Attribute: An attribute is a property or characteristic that describes an entity, rather than defining a relationship between entities. ---

References

1. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. In Chapter 7, Section 7.3.2, "Recursive Relationships, Roles, and Relationship Attributes," it is stated: "If the same entity type participates more than once in a relationship type in different roles, the relationship type is called a recursive relationship." (p. 227).

2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). McGraw-Hill. Chapter 7, "Database Design and the E-R Model," discusses roles in relationships, which is the mechanism for implementing reflexive relationships. For example, in a relationship connecting an entity set to itself, role names are essential to distinguish the function of each participating entity (e.g., manager and worker for the Employee entity set). (Section 7.2.2, p. 283).

3. Ullman, J. D., & Widom, J. (n.d.). The Entity-Relationship Model. Stanford University, CS145 Lecture Notes. The notes describe a "Unary" relationship where an entity set is related to itself, using the example of a Prereq relationship on the Courses entity set. (Section 2.1.4, "Relationships Among Entity Sets").

Scroll to Top