Open In App

GATE | GATE CS 1999 | Question 18

Like Article
Like
Save
Share
Report

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


Last Updated : 24 Oct, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads