Suppose database table T1(P, R) currently has tuples {(10, 5), (15, 8), (25, 6)} and table T2 (A, C) currently has {(10, 6), (25, 3), (10, 5)}. Consider the following three relational algebra queries RA1, RA2 and RA3:
RA1 : T1 ⨝ T1.P = T2.A T2 where ⨝is natural join symbol
RA2 : T1 ⟕ T1.P = T2.A T2 where ⟕ is left outer join symbol
RA3 : T1 ⨝ T1.P = T2.A and T1.R = T2.CT2
The number of tuples in the resulting table of RA1, RA2 and RA3 are given by: