添加数据

--添加到students表数据
INSERT INTO students
 VALUES(10101,NULL,'王晓芳','女','07-5月-1988','计算机');
INSERT INTO students
 VALUES(10205,NULL,'李秋枫','男','25-11月-1990','自动化');
INSERT INTO students
 VALUES(10102,10101,'刘春苹','女','12-8月-1991','计算机');
INSERT INTO students
 VALUES(10301,NULL,'高山','男','08-10月-1990','机电工程');

--添加department表数据
INSERT INTO departments
 VALUES(101,'信息工程','1号教学楼');
INSERT INTO departments
 VALUES(102,'电气工程','2号教学楼');
INSERT INTO departments
 VALUES(103,'机电工程','3号教学楼');
--添加teachers表数据
INSERT INTO teachers
 VALUES(10101,'王彤','教授','01-9月-1990',1000,3000,101);
INSERT INTO teachers
 VALUES(10104,'孔世杰','副教授','06-7月-1994',800,2700,101);
INSERT INTO teachers
 VALUES(10103,'邹人文','讲师','21-1月-1996',600,2400,101);
INSERT INTO teachers
 VALUES(10106,'韩冬梅','助教','01-8月-2001',500,1800,101);


--添加courses表数据
INSERT INTO courses
 VALUES(10101,'计算机组成原理',4);
INSERT INTO courses
 VALUES(10201,'自动控制原理',4);
INSERT INTO courses
 VALUES(10301,'工程制图',3);
INSERT INTO courses
 VALUES(10102,'C++语言程序设计',3);
INSERT INTO courses
 VALUES(10202,'模拟电子技术',4);
 
--添加students_grade表数据 
INSERT INTO students_grade
 VALUES(10101,10101,87);
INSERT INTO students_grade
 VALUES(10101,10201,100);
INSERT INTO students_grade
 VALUES(10101,10301,79);
 
--添加grades表数据
INSERT INTO grades 
 VALUES(1,0,59,'不及格');
INSERT INTO grades 
 VALUES(2,60,69,'不及格');
INSERT INTO grades 
 VALUES(3,70,79,'不及格');
INSERT INTO grades 
 VALUES(4,80,89,'不及格');
INSERT INTO grades 
 VALUES(5,90,100,'不及格');