設學生選課關系模式為SC(Sno,Cno,Grade),其中Sno為學號,Cno為課程號,Grade為成績,SQL查詢語句如下:
SELECT Sno
FROM SC SCX
WHERE NOT EXISTS
(SELECT *
FROM SC SCY
WHERE SCY.Sno=’1042’ AND NOT EXISTS
(SELECT *
FROM SC SCZ
WHERE SCZ.Sno=SCX.Sno AND SCZ.Cno=SCY.Cno)); 與該查詢等價的元組演算表達式為{t|(1)(SC(u)∧SC(v)∧(2)∧t[1]=u[1])。
(1)
(2)
(1)A. A
B. B
C. C
D. D
(2)A. A
B. B
C. C
D. D