视图的规划与操作.pptVIP

【例9-15】根据教学管理部门对学生选课管理的需要，建立关于学生选课信息的视图（视图4） USE 教学管理 CREATE VIEW G_SC_VIEW (sno, sname, scometime, sdepa, smajor, sgpa, cno, cname, grade, odate, oterm, otime, otamou, olaca) AS SELECT S.sno, sname, scometime, sdepa, smajor, sgpa, C.cno, cname,grade, odate, oterm, otime, otamou, olaca FROM student T, enrollment E, offering O, course C WHERE S.sno=E.sno AND E.ono=O.ono AND O.cno=C.cno GO 【例9-16】在G_SC_view视图的基础上，创建学生综合成绩视图（视图5） USE 教学管理 CREATE VIEW S_SCORE_VIEW (sno, sname, MIN_SCORE, MAX_SCORE, AVG_SCRORE) AS SELECT sno, sname, MIN(grade), MAX(grade), AVG(grade) FROM G_SC_VIEW GROUP