DATA-MANAGEMENT-FOUNDATIONS practice question 4 of 15
Which object relates an entity to itself in an entity-relationship model?
Full set: 60 questionsDomain Data Modeling
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.
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. ---
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").
Keep practicing
Take the free DATA-MANAGEMENT-FOUNDATIONS practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-MANAGEMENT-FOUNDATIONS practice questions
- Question 1Which clause is used to specify the join columns when performing a join in MySQL?
- Question 2What is the first step of the analysis phase for designing a database?
- Question 3Which expression can be used to create a temporary name for a table?
- Question 5Which action does the % operator accomplish in MySQL?
- Question 6Which description defines a data type?
- Question 7What is the second step in the implement relationships stage of database design?
