Consider three tables with following number of tuples ineach
X(a,b,c) =100 , Y(d,e,f) =80, Z(x,d,f) =90
Tuples in Y and Z with same value of attribute ’d’ =70
The maximum number of tuples in ( X inner join Y ) full outerjoin Z is ________.
The minimum number of tuples in ( X inner join Y ) full outerjoin Z is ________.
ANYONE CAN PLEASE EXPLAIN IN DETAILS, ANS. IS Max 16900
Min 8090?
NOTE – DON’T BE COPY PASTE FROM GOOGLE, GIVE OWN PERFECTHANDWRITTEN EXPLANATIONS , IN BETTER SIMPLIFICATIONS.
Expert Answer
An answer will be send to you shortly. . . . .