首先,建一个表sc
CREATE TABLE sc(
sno INT,
cno INT,
score INT,
FOREIGN KEY(sno)REFERENCES student(sno),
FOREIGN KEY(cno)REFERENCES course(cno)
);
再给表sc添加数据
INSERT INTO sc(sno,cno,score) VALUES(1,101,87);
INSERT INTO sc(sno,cno,score) VALUES(2,101,66);
INSERT INTO sc(sno,cno,score) VALUES(3,101,55);
INSERT INTO sc(sno,cno,score) VALUES(4,102,90);
INSERT INTO sc(sno,cno,score) VALUES(5,102,39);
INSERT INTO sc(sno,cno,score) VALUES(6,102,19);
INSERT INTO sc(sno,cno,score) VALUES(7,103,77);
INSERT INTO sc(sno,cno,score) VALUES(8,103,78);
INSERT INTO sc(sno,cno,score) VALUES(9,103,93);
INSERT INTO sc(sno,cno,score) VALUES(10,104,33);
INSERT INTO sc(sno,cno,score) VALUES(11,104,46);
INSERT INTO sc(sno,cno,score) VALUES(12,104,87);
INSERT INTO sc(sno,cno,score) VALUES(1,105,68);
INSERT INTO sc(sno,cno,score) VALUES(2,105,54);
INSERT INTO sc(sno,cno,score) VALUES(3,105,90);
INSERT INTO sc(sno,cno,sco