Search for question
Question

[Q2: 5pts] Suppose relation R(A,B) has the following tuples:

A B

1 a

7

t

2

4

10 t

g

0.0

с

and relation S(B,C,D) has the following tuples:

BCD

C 5 6

7 8

a

t 89

Compute the theta-join of R and S with the condition R.B = S.B AND R.A >

S.D. Show the schema of the result relation.

Fig: 1