数据库实验和参考答案(5)

2020-04-14 22:25

where not exists(select * from Course where exists(select * from SC

not

where

Course.Cno=SC.Cno

SC.Sno=student.Sno) ) --48

select Cno,Cname from Course where not exists(select * from SC where exists(select * from student

where

Course.Cno=SC.Cno

SC.Sno=student.Sno) )

and

not

and

--49

select Sname from student,SC,Course where '

and student.Sno in(select Sno from SC where Cno in(select Cno from Course where Cname='数据库基础')) --50

select Sname from student,SC,Course where '

and student.Sno not in(select Sno from SC where Cno in(select Cno from Course where Cname='数据库基础'))

Course.Cno=SC.Cno and

student.Sno=SC.Sno and Cname='VB

Course.Cno=SC.Cno and

student.Sno=SC.Sno and Cname='VB

数据库实验和参考答案(5).doc 将本文的Word文档下载到电脑下载失败或者文档不完整，请联系客服人员解决！