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 337 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.