数据库原理实验报告

查询成功,共有12条记录.

建立’JSJ’系的学生学号、姓名、性别、年龄的视图V_JSJ

create view V_JSJ(sno,sname,ssex,sage) as select sno,sname,ssex,sage from student where sdept='JSJ';

建立视图成功。

建立每门课程的平均分的视图v_average

create view v_average(cno,grade1)

49

as select cno,avg(grade) from sc group by cno;

建立视图成功。

将视图V_JSJ中赵顺的年龄改为21岁.

update V_JSJ set sage=sage+1

where sname='赵顺';

查询成功.

50