SQL 课后习题数据

SQL 课后习题数据

insert into jobcategory values(41,'教务');
insert into jobcategory values(42,'教学');

insert into depart values(10,'办公室','1');
insert into depart values(11,'学术部','2');
insert into depart values(12,'教务处','3');
insert into depart values(13,'教育部','4');

insert into jobs values(31,'教师');
insert into jobs values(32,'办公室主任');
insert into jobs values(33,'教务处主任');
insert into jobs values(34,'教育部部长');
insert into jobs values(35,'教育部副部长');

insert into fund_non values(51,'10001');
insert into fund_non values(52,'10002');
insert into fund_non values(53,'10003');
insert into fund_non values(54,'10004');
insert into fund_non values(55,'10005');
insert into fund_non values(56,'10006');
insert into fund_non values(57,'10007');

insert into staff values(21,'李玉龙','1500','9','教师','教学',51,42,11);
insert into staff values(22,'马帅','1600','11','教师','教学',52,42,11);
insert into staff values(23,'马玮宏','1700','12','办公室主任','教务',53,41,10);
insert into staff values(24,'刘伟','1500','6','教务处主任','教务',54,41,12);
insert into staff values(25,'马永胜','1800','9','教育部部长','教务',55,41,13);
insert into staff values(26,'苏东','1800','5','教育部副部长','教务',56,41,13);
insert into staff values(27,'谭细建','1500','10','教师','教学',57,42,11);

insert into staff_jobs values(21,31);
insert into staff_jobs values(22,31);
insert into staff_jobs values(23,31);
insert into staff_jobs values(23,32);
insert into staff_jobs values(24,31);
insert into staff_jobs values(24,33);
insert into staff_jobs values(25,31);
insert into staff_jobs values(25,34);
insert into staff_jobs values(26,35);
insert into staff_jobs values(27,31);