84.9k views
5 votes
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 one of the following is true about r? entity in e1 is associated with exactly one entity in entity in e1 is associated with more than one entity in entity in e2 is associated with exactly one entity in entity in e2 is associated with at most one entity in e1

1 Answer

2 votes

Final answer:

In an entity-relationship (ER) model, the correct scenario for a many-to-one relationship from entity set e1 to entity set e2 is that each entity in e1 is associated with exactly one entity in e2.

Step-by-step explanation:

In an entity-relationship (ER) model, if there is a many-to-one relationship from entity set e1 to entity set e2, and both e1 and e2 participate totally in the relationship, then one of the following is true about the relationship:

  1. Each entity in e1 is associated with exactly one entity in e2.
  2. Each entity in e1 is associated with more than one entity in e2.
  3. Each entity in e2 is associated with exactly one entity in e1.
  4. Each entity in e2 is associated with at most one entity in e1.

The correct answer is: Each entity in e1 is associated with exactly one entity in e2.

User Tbraun
by
8.2k points