Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

WGU Data Management - Foundations Exam - Topic 2 Question 11 Discussion

Which relationship is shown in the following diagram?
C) Unary relationship
A) Many-to-many
B) Associative entity
D) Intersection data

WGU Data Management - Foundations Exam - Topic 2 Question 11 Discussion

Actual exam question for WGU's WGU Data Management - Foundations exam
Question #: 11
Topic #: 2
[All WGU Data Management - Foundations Questions]

Which relationship is shown in the following diagram?

Show Suggested Answer Hide Answer
Suggested Answer: C

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.


Contribute your Thoughts:

0/2000 characters
Isabelle
7 hours ago
I think this might be a many-to-many relationship, but I'm not entirely sure. I remember something about how entities can relate to each other in multiple ways.
upvoted 0 times
...
Fanny
5 days ago
The diagram looks familiar, but I can't recall if it's intersection data or something else. I should have reviewed more!
upvoted 0 times
...
Bulah
11 days ago
I feel like I might confuse unary relationships with something else. I need to double-check my notes on that.
upvoted 0 times
...
Irma
16 days ago
I remember practicing a question like this where the answer was an associative entity. Could it be that here too?
upvoted 0 times
...
Elin
2 months ago
I think this might be a many-to-many relationship, but I'm not entirely sure.
upvoted 0 times
...

Save Cancel