q2 5pts suppose relation r a b has the following tuples a b 1 a 7 t 2
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.