Open In App

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

Article Tags :