GATE | GATE CS 1999 | Question 18

Consider the join of a relation R with a relation S. If K has m tuples and S has n tuples, then the maximum and minimum sizes of the join respectively are:
(A) m+n and 0
(B) mn and 0
(C) m+n and m-n
(D) mn and m+n

Answer: (B)

Explanation: When there is no foreign key constraint between two tables then the max and min number of tuples in their join is mn and 0 respectively.

Quiz of this Question

My Personal Notes arrow_drop_up
Article Tags :

Be the First to upvote.

Please write to us at to report any issue with the above content.