設(shè)學(xué)生選課關(guān)系模式為SC(Sno,Cno,Grade),其中Sno為學(xué)號(hào),Cno為課程號(hào),Grade為成績(jī),SQL查詢(xún)語(yǔ)句如下:
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)); 與該查詢(xún)等價(jià)的元組演算表達(dá)式為{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