Which relationship is shown in the following diagram?
A.
Many-to-many
B.
Associative entity
C.
Unary relationship
D.
Intersection data
The Answer Is:
C
This question includes an explanation.
Explanation:
The given diagram represents a unary relationship (also called a recursive relationship), which occurs when an entity is related to itself. In this case, salespersons back each other up, meaning a salesperson is associated with another salesperson from the same entity.
Key Observations from the Diagram:
Single Entity (Salesperson)
The table contains only one entity type, Salesperson, which has attributes such as Salesperson Number, Name, Commission, Percentage, and Year of Hire.
Self-Referencing Relationship (Backs-up and Backed-up by)
The diagram shows that a salesperson can back up another salesperson.
This means that the relationship exists within the same entity rather than between two different entities.
Cardinality (One-to-One Relationship in a Unary Form)
The notation ( |—| ) in the ER diagram indicates a one-to-one recursive relationship.
One salesperson can back up only one other salesperson, and each salesperson is backed up by only one.
Data-Management-Foundations PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 75% Discount on All Products,
Use Coupon: "ac75sure"