8. (10%) Two relations, T1 and T2 are given. T1(A,B) has data: and T2(B,C,D) has data:...

   

Transcribed Image Text:

8. (10%) Two relations, T1 and T2 are given. T1(A,B) has data: and T2(B,C,D) has data: A B 12 34 5 6 BCD 246 468 479 What is the result of the outerjoin of T1 and T2, where the condition is: T1.A>T2.B AND T1.B-T2.C. (Which tuples of T1 or T2 are dangling (and therefore needs to be padded in the outerjoin)?) 8. (10%) Two relations, T1 and T2 are given. T1(A,B) has data: and T2(B,C,D) has data: A B 12 34 5 6 BCD 246 468 479 What is the result of the outerjoin of T1 and T2, where the condition is: T1.A>T2.B AND T1.B-T2.C. (Which tuples of T1 or T2 are dangling (and therefore needs to be padded in the outerjoin)?)