3.sql

大学时做的数据库实验

use student_class
create table SC
(sclass varchar(2),--班级
sno varchar(2),--编号
cno varchar(3),--课程号
grade real check(grade<=100.0 and grade>=0.0), --成绩
primary key(sclass,sno,cno),
foreign key (cno) references Course (cno),
foreign key (sno,sclass) references Student(sno,sclass)
)
insert into SC(Sclass,Sno,Cno,grade)
values(1,1,1,92)  
insert into SC(Sclass,Sno,Cno,grade)
values(1,1,2,85)  
insert into SC(Sclass,Sno,Cno,grade)
values(1,1,3,88)  
insert into SC(Sclass,Sno,Cno,grade)
values(1,2,2,90)  
insert into SC(Sclass,Sno,Cno,grade)
values(1,2,3,80)  
insert into SC(Sclass,Sno,Cno,grade)
values(2,1,1,75)  
insert into SC(Sclass,Sno,Cno,grade)
values(2,1,2,92)  
insert into SC(Sclass,Sno,Cno,grade)
values(2,2,2,87)  
insert into SC(Sclass,Sno,Cno,grade)
values(2,2,3,89)  
insert into SC(Sclass,Sno,Cno,grade)
values(2,3,1,90)