. Suppose relations R(A,B) and S(B,C,D) are as follows:
R = A B
1 2
3 4
5 6
S = B C D
4 5 1
6 7 2
8 9 3
Compute the full outer natural join on B, the left outer natural join on B, and the right outer natural join on B. In each case, R is the left operand and S is the right operand. Then, answer the following questions for each of the three results:
How many rows are there in the result?
How many NULL's appear in the result.
Finally, find the correct statement in the list below. a) The left outer natural join has 5 rows.
b) The right outer natural join has 3 NULL's.
c) The full outer natural join has 4 rows.
d) The right outer natural join has 2 NULL's.