createview.sql

来自「一个基于swing组件的java程序」· SQL 代码 · 共 51 行

--管理员视图
create view is_adm
as
select * from admininfo
--学生视图
create view is_stu
as
select * from student
--学生信息视图
create view is_stuinfo
as
select sno,sname,sex,dname from student,department
where student.dno=department.dno
--选课纪录视图
create view is_sc
as
select * from sc
--学生已选课信息显示
create view gotc_stu
as
select student.sno,course.cno,cname,credit,major
from sc,course,dc,student
where student.sno=sc.sno and student.dno=dc.dno and sc.cno=dc.cno and sc.cno=course.cno

--学生添加选课视图
create view addc_stu
as 
select dno,dc.cno,cname,credit,major
from dc,course
where dc.cno=course.cno
with check option;

--开设课程视图
create view is_dc
as
select * from dc
--院系视图
create view is_depart
as
select * from department
--课程视图
create view is_cou
as
select * from course
--开设课程信息视图
create view is_dcinfo
as
select dno,dc.cno,cname,major
from dc,course
where dc.cno=course.cno