retagged by
441 views
0 votes
0 votes

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)
retagged by

1 Answer

Related questions