in Databases retagged by
328 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)
in Databases retagged by
328 views

1 Answer

3 votes
3 votes

option B will be correct....

1 comment

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

Related questions