retagged by
2,403 views
1 votes
1 votes

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
retagged by

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

0 votes
0 votes
4 answers
2
admin asked Mar 30, 2020
4,902 views
Consider the relational schema $R(A B C D)$ with following $FD$ set $F=\{A \to CE, B \to D, AE \to D\}$. Identify the highest normal form satisfied by the relation $R$.$2...
3 votes
3 votes
2 answers
4