insertcourse.sql

学生信息管理系统

insert into course values('K001','计算机操作基础','1','必修课','40','3')
insert into course values('K002','C++','2','必修课','80','4')
insert into course values('K003','Java','3','必修课','120','4')
insert into course values('K004','JavaWeb开发','4','必修课','80','4')
insert into course values('K005','软件建模','4','必修课','40','3')

insert into course values('K121','马克思主义哲学','1','选修课','20','2')
insert into course values('K122','毛泽东思想导论','2','选修课','20','2')
insert into course values('K123','法律','3','选修课','20','2')

insert into teacher_class_course values('A001','C001','K001','1')
insert into teacher_class_course values('A001','C001','K004','4')
insert into teacher_class_course values('A002','C001','K002','2')
insert into teacher_class_course values('A002','C001','K003','3')
insert into teacher_class_course values('A003','C001','K005','3')

insert into teacher_student_course values('17','A004','K121','1')
insert into teacher_student_course values('28','A004','K122','2')
insert into teacher_student_course values('17','A005','K123','3')

insert into exam values('K001','17','王向中','1','考试课','2005/12','第九机房')
insert into exam values('K002','17','张卫','2','考试课','2006/6','第九机房')
insert into exam values('K003','17','张卫','3','考试课','2006/12','第九机房')
insert into exam values('K004','17','王向中','4','考试课','2007/6','第九机房')
insert into exam values('K001','18','王向中','1','考试课','2005/12','第九机房')
insert into exam values('K002','28','张卫','2','考试课','2006/6','第九机房')
insert into exam values('K003','28','张卫','3','考试课','2006/12','第九机房')
insert into exam values('K004','28','王向中','4','考试课','2007/6','第九机房')

insert into exam values('K121','17','董陶陶','1','考察课','2005/12','1-202')
insert into exam values('K122','28','董陶陶','2','考察课','2006/6','1-202')

insert into compulsory_score values('17','K001','1','80','2005/12','C001','')
insert into compulsory_score values('28','K001','1','75','2005/12','C001','')
insert into compulsory_score values('17','K002','2','87','2006/6','C001','')
insert into optional_score values('17','K121','1','良好','','2005/12')
insert into optional_score values('28','K122','2','良好','','2006/6')