#newgradiance #dbms #sql #joins Q4

Question

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)

Answer 1

option B will be correct....

Comments

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