CREATE TABLE scott.score
(
编号 number(10,0) not null primary key ,
学号 char(10) not null,
课程号 char(4) not null,
成绩 number(3, 0) ,
foreign key (学号) references scott.student(学号) ,
foreign key (课程号) references scott.course(课程号) ,
CONSTRAINT score_check check ( 成绩 is null or (成绩 <=100 and 成绩 >0) )
);
INSERT INTO scott.score VALUES (1,'2009030101', 'J001', 99);
INSERT INTO scott.score VALUES (2,'2009030101', 'J002', 77);
INSERT INTO scott.score VALUES (3,'2009030101', 'J005', 86);
INSERT INTO scott.score (编号,学号,课程号) VALUES (4,'2009030101', 'A001');
INSERT INTO scott.score (编号,学号,课程号) VALUES (5,'2009030101', 'A002');
INSERT INTO scott. score (编号,学号,课程号) VALUES (6,'2009030101', 'A005');
INSERT INTO scott.score (编号,学号,课程号) VALUES (7,'2009030102', 'A001');
INSERT INTO scott.score (编号,学号,课程号) VALUES (8,'2009030102', 'A002');
INSERT INTO scott.score VALUES (9,'2009030102', 'A005', 78);
INSERT INTO scott.score VALUES (10,'2009030102', 'J001', 44);
INSERT INTO scott.score VALUES (11,'2009030102', 'J005', 76);
INSERT INTO scott.score VALUES (12,'2009030102', 'J003', 74);
INSERT INTO scott.score (编号,学号,课程号) VALUES (13,'2009030103', 'A001');
INSERT INTO scott.score (编号,学号,课程号) VALUES (14,'2009030103', 'A002');
INSERT INTO scott.score (编号,学号,课程号) VALUES (15,'2009030103', 'A005');
INSERT INTO scott.score (编号,学号,课程号) VALUES (16,'2009030103', 'J005');
INSERT INTO scott.score (编号,学号,课程号) VALUES (17,'2009030103', 'J002');
INSERT INTO scott.score (编号,学号,课程号) VALUES (18,'2009030103', 'J003');
INSERT INTO scott.score VALUES (19,'2009030104', 'A001', 85);
INSERT INTO scott.score VALUES (20,'2009030104', 'A002', 83);
INSERT INTO scott.score VALUES (21,'2009030104', 'A005', 71);
INSERT INTO scott.score (编号,学号,课程号) VALUES (22,'2009030104', 'J001');
INSERT INTO scott.score (编号,学号,课程号) VALUES (23,'2009030104', 'J002');
INSERT INTO scott.score (编号,学号,课程号) VALUES (24,'2009030104', 'J003');
INSERT INTO scott.score VALUES (25,'2009030105', 'A001', 64);
INSERT INTO scott.score VALUES (26,'2009030105', 'A002', 61);
INSERT INTO scott.score VALUES (27,'2009030105', 'A005', 86);
INSERT INTO scott.score (编号,学号,课程号) VALUES (28,'2009030105', 'J001');
INSERT INTO scott.score (编号,学号,课程号) VALUES (29,'2009030105', 'J002');
INSERT INTO scott.score (编号,学号,课程号) VALUES (30,'2009030105', 'J005');
INSERT INTO scott.score VALUES (31,'2009030301', 'A005', 33);
INSERT INTO scott.score (编号,学号,课程号) VALUES (32,'2009030301', 'J001');
INSERT INTO scott.score (编号,学号,课程号) VALUES (33,'2009030301', 'J002');
INSERT INTO scott.score (编号,学号,课程号) VALUES (34,'2009030301', 'J003');
INSERT INTO scott.score (编号,学号,课程号) VALUES (35,'2009030302', 'J001');
INSERT INTO scott.score (编号,学号,课程号) VALUES (36,'2009030302', 'J005');
INSERT INTO scott.score (编号,学号,课程号) VALUES (37,'2009030302', 'J003');
INSERT INTO scott.score VALUES (38,'2009030302', 'A001', 77);
INSERT INTO scott.score VALUES (39,'2009030302', 'A002', 83);
INSERT INTO scott.score VALUES (40,'2009030302', 'A005', 64);
INSERT INTO scott.score (编号,学号,课程号) VALUES (41,'2009030303', 'J005');
INSERT INTO scott.score (编号,学号,课程号) VALUES (42,'2009030303', 'J002');
INSERT INTO scott.score (编号,学号,课程号) VALUES (43,'2009030303', 'J003');
INSERT INTO scott.score VALUES (44,'2009030303', 'A001', 97);
INSERT INTO scott.score VALUES (45,'2009030303', 'A002', 93);
INSERT INTO scott.score VALUES (46,'2009030303', 'A005', 94);
INSERT INTO scott.score (编号,学号,课程号) VALUES (47,'2009030304', 'J001');
INSERT INTO scott.score (编号,学号,课程号) VALUES (48,'2009030304', 'J005');
INSERT INTO scott.score (编号,学号,课程号) VALUES (49,'2009030304', 'J002');
INSERT INTO scott.score (编号,学号,课程号) VALUES (50,'2009030304', 'J003');
INSERT INTO scott.score VALUES (51,'2009030304', 'A001', 87);
INSERT INTO scott.score VALUES (52,'2009030304', 'A002', 81);
INSERT INTO scott.score VALUES (53,'2009030304', 'A005', 77);