Question

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 that the cardinality of E2.Which one of the following is true about R?

a.Every entity in E1 is associated with exactly one entity in E2.
b.Some entity in E1 is associated with more than one entity in E2.
c.Every entity in E2 is associated with exactly one entity in E1.
d.Every entity in E2 is associated with at most one entity in E1

Answer 1

The correct answer is option b, where some entity in E1 is associated with more than one entity in E2. In an Entity-Relationship (ER) model, a many-to-one relationship means that multiple entities from E1 can be associated with a single entity in E2.

Step-by-step explanation:

In an Entity-Relationship (ER) model, a many-to-one relationship means that multiple entities from E1 can be associated with a single entity in E2. Since E1 has a greater cardinality than E2, it means that there are more entities in E1 than in E2. Therefore, the correct answer is Option b. Some entity in E1 is associated with more than one entity in E2.