5
Answer (Choose 1 answer)
Here are three relations, R(A,B), S(C,D), and T(E.F). (see figure)
B Compute the result of the query:
SELECT A, F. SUM(C), SUM(D)FROM R, S, T
WHERE B = CAND D = E GROUP BY A, F
HAVING COUNT(*) > 1
Identify, in the list below, the row that appears in the result.
Α. (1.1.2.2)
Β. (1.1.1.1)
C. None of the others
D. (1.1,2.1)
R
0
1
1
S
1
0
1
0
1
0
1
1
0
1
1
T
Ext