创建数据库
create database stuinfo
use stuinfo
创建表
创建主表 major
create table major{
mno int,
mname varchar{20},
primary key(mno)
}
select * form major;
创建学生信息表 stu
create table stu{
sno int,
sname Varchar(30),
age smallint,
sex bit,
mno int,
primary key(sno),
foreign key(mno) references major(mno)
}
select * from stu;
创建课程表 cou
create table cou{
cno int,
cname varchar{30},
ctime smallint,
ccredit decimal(4,2),
primary key(cno)
}
创建成绩表 sc
create table sc{
sno int,
cno int
grade decimal(5,2)
primary key(sno,cno)
foreign key (sno) references stu(sno)
foreign key (cno) references cou(cno)
}