Which of the following options appropriately represent the relationship shown…
2022
Which of the following options appropriately represent the relationship shown in the diagram? (E1 to E2)
E1 ─── R ───▷ E2
- A.
ONE-TO-ONE
- B.
ONE-TO-MANY
- C.
MANY-TO-ONE
- D.
MANY-TO-MANY
Attempted by 2107 students.
Show answer & explanation
Correct answer: C
In an ER diagram, the arrow (▷) towards E2 indicates a key constraint.
So,
E1 ─── R ───▷ E2
means:
Each entity in E1 is associated with at most one entity in E2 through relationship R.
Multiple entities of E1 may be associated with the same entity of E2.
Therefore, the relationship is:
Many-to-One (N:1) from E1 to E2
or equivalently,
One-to-Many (1:N) from E2 to E1.