create table Student(
Sid varchar(6) primary key,
Sname varchar(10) not null,
Sage int check(Sage>0 and Sage<=150),
Ssex varchar(2) check(Ssex='男'or Ssex='女'),
Szhuanye varchar(20) not null
)engine=innoDB default charset=utf8;
create table Course(
Cid varchar(4) primary key,
Cname varchar(20) not null,
Cxueshi int check(Ctime>0),
Teacher varchar(10) not null
)engine=innoDB default charset=utf8;
create table Score(
SCid int primary key auto_increment,
Sid varchar(6) ,
foreign key (Sid) references Student (Sid),
Cid varchar(4),
foreign key (Cid) references Course (Cid),
Score int check(Score>=0 and Score <=100)
)engine=innoDB default charset=utf8;
Sid varchar(6) primary key,
Sname varchar(10) not null,
Sage int check(Sage>0 and Sage<=150),
Ssex varchar(2) check(Ssex='男'or Ssex='女'),
Szhuanye varchar(20) not null
)engine=innoDB default charset=utf8;
create table Course(
Cid varchar(4) primary key,
Cname varchar(20) not null,
Cxueshi int check(Ctime>0),
Teacher varchar(10) not null
)engine=innoDB default charset=utf8;
create table Score(
SCid int primary key auto_increment,
Sid varchar(6) ,
foreign key (Sid) references Student (Sid),
Cid varchar(4),
foreign key (Cid) references Course (Cid),
Score int check(Score>=0 and Score <=100)
)engine=innoDB default charset=utf8;