学生表student(sno学号,sname姓名,ssex性别,sage年龄,sdept所在系)
课程表course(cno课程号,cname课程名,credit学分,semester学期)
成绩表sc(sno学号,cno课程号,grade成绩)
1、创建student表,课程表course表,sc表
create table student (
sno char(7) primary key , /主码约束/
sname char(10) not null, /非空约束/
sage tinyint, /存储0-255之间的整数/
sdept char(20),
)
create table course (
cno char(6) not null,
cname char(20) not null,
credit tinyint,
semester tinyint,
primary key(cno)
)
create table sc (
sno char(7) not null,
cno char(6) not null,
grade tinyint,
primary key(sno,cno),
foreign key(sno) references student(sno),/主码,引用student表外码/
foreign key(cno) references course(sno), /主码,引用course表外码/