1 votes 1 votes Consider the join of 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 $|m-n|$ $mn$ and $0$ $mn$ and $m+n$ Databases tbb-dbms-1 + – Bikram asked Nov 26, 2016 edited Aug 21, 2019 by Counsellor Bikram 319 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 1 votes 1 votes here option C is correct because here we find join so first we performed cross-product then so maximum in which no attribute is common so it multiple every element so its m*n but if we talk about minimum means suppose R= m tuple and S= n tuple(0 tuple) so here cross product no pair is result so its min is 0. Hradesh patel answered Dec 19, 2016 selected Jul 5, 2017 by Bikram Hradesh patel comment Share Follow See all 0 reply Please log in or register to add a comment.