In an Entity-Relationship (ER) model, suppose $R$ is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in $R$ and that the cardinality of E1 is greater than the cardinality of E2.
Which one of the following is true about $R$?
Every entity in E1 is associated with exactly one entity in E2.
Some entity in E1 is associated with more than one entity in E2.
Every entity in E2 is associated with exactly one entity in E1.
Every entity in E2 is associated with at most one entity in E1.
Correct answer: (A) Every entity in E1 is associated with exactly one entity in E2.
Explanation
Many-to-one with total participation of E1 means every entity in E1 maps to exactly one entity in E2. Since $|E1|>|E2|$, some E2 entity is used by several E1 entities, so C and D fail.
More ER-Model and Database Architecture questions
GATE 2015 CS (CS1) Q48– Consider an Entity-Relationship (ER) model in which entity sets E 1 and E 2 are connected…
GATE 2017 CS (CS2) Q27– Entity types A and B are connected by relationship R with no attributes. When can the…
GATE 2012 CS Q24– For basic ER and relational models, which is incorrect?
GATE 2021 CS (CS2) Q16– S1: A relation schema can have at most one foreign key. S2: A foreign key in schema R…
GATE 2008 CS Q82– For the ER diagram shown, what minimum number of tables represents M, N, P, R1, R2?
GATE 2008 CS Q83– For the ER diagram from Q82, which is a correct attribute set for one resulting table?