今天上课老师要我们建立一个学生排课系统的表
create table s
(
s# char(4) not null,
sname char(8) not null,
age smallint,
sex char(1),
primary key (s#));
create table c
(
c# char(5) not null,
cname char(10) not null,
teacher char(9),
primary key (c#));
create table sc
(
s# char(4) not null,
c# char(5) not null,
grade smallint not null,
primary key (s#,c#),
foreign key(s#)references s(s#),
foreign key(c#)references c(c#),
check (grade between 0 and 100));