INSERT INTO TB_STUDENT(STUDENTID,STUNAME,SEX,AGE) VALUES(
'20141101'
,
'SIM'
,
'BOY'
,22);
INSERT INTO TB_STUDENT(STUDENTID,STUNAME,SEX,AGE) VALUES(
'20141102'
,
'MARY'
,
'GIRL'
,22);
INSERT INTO TB_STUDENT(STUDENTID,STUNAME,SEX,AGE) VALUES(
'20141103'
,
'SILLY'
,
'GIRL'
,22);
INSERT INTO TB_STUDENT(STUDENTID,STUNAME,SEX,AGE) VALUES(
'20141104'
,
'ALICE'
,
'GIRL'
,22);
INSERT INTO TB_STUDENT(STUDENTID,STUNAME,SEX,AGE) VALUES(
'20141105'
,
'SAM'
,
'BOY'
,22);
insert into tb_course(COURSEID,coursename,teacher) VALUES(
'1001'
,
'MATH'
,
'SA'
);
insert into tb_course(COURSEID,coursename,teacher) VALUES(
'1002'
,
'ENGLISH'
,
'ALICE'
);
insert into tb_course(COURSEID,coursename,teacher) VALUES(
'1003'
,
'JAVA'
,
'BB'
);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10001'
,
'1001'
,
'20141101'
,99);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10002'
,
'1001'
,
'20141102'
,88);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10003'
,
'1001'
,
'20141103'
,77);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10004'
,
'1001'
,
'20141104'
,98);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10005'
,
'1001'
,
'20141105'
,96);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10006'
,
'1002'
,
'20141101'
,99);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10007'
,
'1002'
,
'20141103'
,99);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10008'
,
'1002'
,
'20141104'
,99);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10009'
,
'1003'
,
'20141102'
,99);
INSERT INTO TB_SCORE(SCOREID,COURSEID,STUDENTID,GRADE) VALUES(
'10010'
,
'1003'
,
'20141105'
,99);