Maximum and minimum number of tuples joins


#1

Consider 3 tables with following number of tuples in each
S(a,b,c) = 10, R(a,d,e) = 8, T(x,d,f) = 9

Tuples in S and R with same value of attribute ‘a’ = 6
Tuples in R and T with same value of attribute ‘d’ = 7

What is the maximum and minimum number of tuples in ( ( S left outer join R) full outer join T ) ?

A. 13 12
B. 15 14
C. 14 13
D. 14 12


#2

Maximum number of tuples can be found out just by taking 6 common attributes of ‘d’ instead of 7, which would yield answer to be 14.

So correct answer is option C.


#3

C is the right answer


#4

for maximum you are wrong .
we should take 5 common attributes of d not 6 because if you will take 6 common attributes then for full outer join
6+ (10-6)+(9-6)=6+4+3=13 again.
so actually for minimum we should take 6 d common
and for maximum we should take 5 d common.