486 views
0 votes
0 votes

Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential integrity constraint:

  1.  9 and 0
  2.  9 and 9
  3.  9+100 and 0
  4.  9*100 and 9

2 Answers

1 votes
1 votes
B 9 and 9

Bcoz of referential integrity at Max only 9 tuples can be matched in join

Related questions

1 votes
1 votes
2 answers
3
gatecse asked Dec 9, 2020
510 views
Domain constraints, functional dependency and referential integrity are special forms of _______Foreign keyPrimary keyAssertionReferential constraint