328 views

Suppose relations R(A,B) and S(B,C,D) have the tuples shown below:

R =
A B
1 2
3 4
5 6
S =
B C D
2 4 6
4 6 8
4 7 9

Compute the result of the join query:

     SELECT A, R.B, S.B, C, D
FROM R, S
WHERE R.A < S.C AND R.B < S.D

 Then, identify one of the tuples in the result from the list below.
 a) (1,2,2,6,8) b) (1,2,2,4,6) c) (3,4,4,7,8) d) (3,4,5,7,9)

option B will be correct....

### 1 comment

Yes. Option b) will be the correct answer. Thanks for the explanation.