vb.paike.zip_排课_排课系统_机房排课

create database paike use paike create table t_student ( 学号 varchar(30), 班级号 varchar(20), 姓名 varchar(30) ) insert into t_student values('tb0902701','sfcc09001','刘德华') insert into t_student values('tb0902702','sfcc09002','古天乐') insert into t_student values('tb0902703','sfcc09003','郭富城') insert into t_student values('tb0902704','sfcc09004','张学友') insert into t_student values('tb0902705','sfcc09005','谢霆锋') insert into t_student values('tb0902806','sfcc09006','胡彦斌') select * from t_student create table t_teacher ( 教师编号 varchar(20), 教师名称 varchar(20) ) delete from t_teacher where 教师编号='fb090101' update t_teacher set 教师编号='fb090101' where 教师编号='fb090103' insert into t_teacher values('fb090101','柳明') insert into t_teacher values('fb090102','杨虎') insert into t_teacher values('fb090103','秦海波') insert into t_teacher values('fb090104','徐亚丽') insert into t_teacher values('fb090105','李莹洁') insert into t_teacher values('fb090106','丁云强') create table t_comroom ( 机房编号 varchar(20), 机房名称 varchar(30) ) insert into t_comroom values('C0001','计算机一房') insert into t_comroom values('C0002','计算机二房') insert into t_comroom values('C0003','计算机三房') insert into t_comroom values('C0004','计算机四房') insert into t_comroom values('C0005','计算机五房') insert into t_comroom values('C0006','计算机六房') create table t_class ( 班级编号 varchar(20), 班级名称 varchar(30) ) insert into t_class values('sfcc09001','软件一班') insert into t_class values('sfcc09002','软件二班') insert into t_class values('sfcc09003','软件三班') insert into t_class values('sfcc09004','软件四班') insert into t_class values('sfcc09005','软件五班') insert into t_class values('sfcc09006','软件六班') create table t_course ( 课程编号 varchar(20), 课程名称 varchar(20) ) insert into t_course values('k001','编程设计') insert into t_course values('k002','编程入门') insert into t_course values('k003','计算机入门') insert into t_course values('k004','职业素质') insert into t_course values('k005','专业英语') insert into t_course values('k006','质素拓展') create table t_syllabus ( 机房编号 varchar(20), 班级编号 varchar(20), 教师编号 varchar(20), 课程编号 varchar(20), 星期 varchar(20), 课次 varchar(20) ) insert into t_syllabus values('C0001','sfcc09006','fb090101','k001','星期一','1-2') insert into t_syllabus values('C0001','sfcc09006','fb090101','k001','星期一','3-4') insert into t_syllabus values('C0003','sfcc09006','fb090102','k001','星期一','5-6') insert into t_syllabus values('C0003','sfcc09006','fb090102','k001','星期一','7-8') insert into t_syllabus values('C0002','sfcc09006','fb090104','k002','星期二','1-2') insert into t_syllabus values('C0002','sfcc09006','fb090104','k002','星期二','3-4') insert into t_syllabus values('C0001','sfcc09006','fb090105','k002','星期二','7-8') insert into t_syllabus values('C0005','sfcc09006','fb090103','k003','星期三','1-2') insert into t_syllabus values('C0005','sfcc09006','fb090103','k003','星期三','5-6') insert into t_syllabus values('C0006','sfcc09006','fb090104','k004','星期四','3-4') insert into t_syllabus values('C0004','sfcc09006','fb090104','k004','星期四','5-6') insert into t_syllabus values('C0004','sfcc09006','fb090104','k004','星期四','7-8') insert into t_syllabus values('C0003','sfcc09006','fb090105','k005','星期五','1-2') insert into t_syllabus values('C0002','sfcc09006','fb090105','k005','星期五','5-6') insert into t_syllabus values('C0002','sfcc09006','fb090105','k005','星期五','7-8') insert into t_syllabus values('C0006','sfcc09006','fb090106','k006','星期六','1-2') insert into t_syllabus values('C0006','sfcc09006','fb090106','k006','星期六','3-4') create view ve_Arrange as select e.机房编号,A.机房名称,e.班级编号,B.班级名称,e.教师编号,C.教师名称,e.课程编号,D.课程名称,E.星期,E.课次 from t_comroom A, t_class B,t_teacher C,t_course D,t_syllabus E where E.机房编号=A.机房编号 AND E.班级编号=B.班级编号 AND E.教师编号=C.教师编号 AND E.课程编号=D.课程编号 select * from ve_Arrange