数据库原理及应用孟彩霞版实验3~8 - 图文

select Sno,Sname,Sex,Age from 学生表Student where Sdept='CS' with check option

55

create view 学生表student_course_2 as

select 学生表Student.Sno,Sname,Sex,Age,Cno,Grade from 学生表Student,学生选课表SC

where 学生表Student.Sno=学生选课表SC.Sno and Grade>=80 and Cno='2'

56

create view 学生表student_birth(Sno,Sname,Sbirth) as

select Sno,Sname,2008-Age from 学生表Student

57

select Sno,Sname

from c_学生表student

where Age between 18 and 22

58

select Sno,Sname

from 学生表student_course_2 where Sex='女' and Grade>=90

59

update c_学生表student set Sname = '张良' where Sno='201010'

60 61

DELETE

FROM c_学生表student WHERE Sno= '201007';

（2）1）

CREATE VIEW Bj_orders(orderid,goodsname,quantity,customerid,cname) AS

select orderid,goodsname,quantity,orders.customerid,cname from orders,customers,goods

where customers.customerid=orders.customerid and goods.goodsid=orders.goodsid and city='beijing'

2） Select*

from Bj_orders

where Cname='张三'

试验7

1） JWGL第四章，例1，3~7

1. create procedure 学生表student_course as

select 学生表student.Sno,Sname,Cname,Grade

from 学生表student,课程表Course,学生选课表SC

where 学生表student.Sno=学生选课表SC.Sno and 课程表Course.Cno= 学生选课表SC.Cno and Sname='刘伟';