学生信息表:
create table LJ_STU
(
STID NUMBER(10),
STNAME VARCHAR2(100)
);
1 Mary
2 Lily
3 Jack
4 Lucy
5 Sun
6 Roy
7 Jane
8 Mike
9 Anny
10 Davi
11 DR
12 Robin
课程表
create table LJ_COURSE
(
CID NUMBER(10),
CNAME VARCHAR2(100)
);
1 English
2 Chinese
3 Math
4 Chemistry
5 Physics
6 Geography
7 Creature
8 History
学生成绩表
create table LJ_ST_SCORE
(
SID NUMBER(10),
CID NUMBER(10),
SCORE NUMBER(10)
);
SID CID SCORE
1 1 90
1 2 78
1 3 99
1 4 85
1 5 71
1 6 45
1 7 60
1 8 56
2 1 40
2 2 56
2 3 59
2 4 55
2 5 71
2