in Databases retagged by
2,412 views
1 vote
1 vote

The condition for total participation of entity in a relationship is _______.

  1. Maximum cardinality should be one
  2. Minimum cardinality should be one
  3. Minimum cardinality should be zero
  4. None of the options
in Databases retagged by
by
2.4k views

1 comment

option b.

0
0

1 Answer

3 votes
3 votes

Total Participation of an entity in a relationship means that all the tuples in that entity should be in the relationship. That is, all the tuples of the entity set are participating in the relationship. So, the relationship set will contain at least one tuple for each tuple in the entity set. 

In other words, the minimum cardinality of that cardinality set should be one.

(B) Minimum cardinality should be one

NOTE: Partial participation is when there can be some tuples in the entity set which do not participate in the relationship. So, for partial participation, minimum cardinality will be zero.

Answer:

Related questions