Suppose relation R(A,B) has the tuples:
A B
-------------------
10 x
30 y
50 z
70 t
and the relation S(B,C,D) has tuples:
B C D
------------------------------------
x 40 60
z 60 80
z 50 50
z 70 90
a. (10,x)
b. (30,y)
c. (50,z)
d. (70,t)
A B
-------------------
10 x
30 y
50 z
70 t
and the relation S(B,C,D) has tuples:
B C D
------------------------------------
x 40 60
z 60 80
z 50 50
z 70 90
Compute the right outer join of R and S, where the condition is: R.B = S.B. Then identify 2 tuples of R that do not appear in the computed result.
a. (10,x)
b. (30,y)
c. (50,z)
d. (70,t)
Answer: B and D.