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')