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
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
Please Login to comment...