A B C D E
4 5 6 4 8
7 8 9 7 5
π3,2 σA=D(R×S)
C B
6 5
9 8
(2)不是
(3)create view view2 as select distinct PNO,SNO from SPJ
(4)update P set WEIGHT=WEIGHT+100 where PNO='02277'
select PNAME from P where PNO='02277'
(5)select c# from c where c# not in
(select c# from sc where s# in
(select s# from s where sname='wang'))
πc#(σ(c#!=πc#(σ(s#=(πs#(σ(sname='wang')s)))sc))c#)
(6)所有學生都選擇了的課程編號,課程名
select c#,cname from c where c# in (select c# from
(select c#,count(s#) from sc group by c# having
count(s#)=(select count(s#) from s))as a)
(7)insert into student select s#,sname,sex from s where s# not in(select s# from sc where c#<80)