Here are three relations, R(a,b), S(a,b), and T(a,b). Their current values are:
Compute the result of the query:
SELECT R.a, R.b, S.b, T.b
FROM R, S, T
WHERE R.b = S.a AND S.b <> T.b
Identify, in the list below, the true statement about whether or not a tuple appears in the output, and how many times it appears.
a) |
(1,0,0,1) appears once. |
b) |
(0,0,1,1) appears twice. |
c) |
(0,1,1,1) does not appear. |
d) |
(1,1,1,0) appears once. |