5 5 votes Consider the join of a relation $R$ with a relation $S$. If $R$ has $m$ tuples and $S$ has $n$ tuples then the maximum and minimum sizes of the join respectively are$m+n$ and $0$ $m n$ and $0$ $m+n$ and $|m-n|$ $m n$ and $m+n$ Databases goclasses databases goclasses-cs-dpp goclasses-cs-dpp-day-51 goclasses-databases-practice-questions + – GO Classes 529 views answer comment Share Follow Print 0 reply Please log in or register to add a comment.
4 4 votes The maximum number of tuples can be $m n$. This happens in two cases. Case $1$: if there is a common attribute between $R$ and $S$, and every row of $r$ matches with the each row of $s$ i.e., it means, the join attribute has the same value in all the rows of both $r$ and $s$, Case $2$ : If there is no common attribute between $R$ and $S$. The minimum number of tuples is $0$ . This happens when there is a common attribute between $R$ and $S$ and it has no common value between the two relations. GO Classes answered Jul 20, 2025 • reshown Jul 22, 2025 by GO Classes Support GO Classes comment Share Follow 0 reply Please log in or register to add a comment.
0 0 votes Answer: Option B Maximum number of tuples will be: m*n Minimum number of tuple will be : 0 (if there is no common attribute) Rajkumar Chaudhary answered Oct 22, 2025 1 flag: ✌ Edit necessary (Aambo04 “wrong answer. Minimum = 0 when there is common atribute but none of its values in R matches with S correspoinding attribut value.”) Rajkumar Chaudhary comment Share Follow 0 reply Please log in or register to add a comment.
