数据库笔记---表的完整性约束条件

一、建表:

create table student
(
sno char(9) primary key,
sname char(2) unique,
ssex char(2),
sage char(2),
sdept char(20)
);
alter table student modify(sname char(20));

create table course
(
cno char(4) primary key,
cname char(40) not null,
cpno char(4) references course(cno),
ccredit smallint
);
create table sc
(
sno char(9) references student(sno),
cno char(4),
grade smallint,
primary key(sno,cno),
foreign key(cno) references course(cno)
);

insert into student values('201215121', '李勇', '男', '20', 'CS');
insert into student values('201215122', '刘晨', '女', '19', 'CS');
insert into student values('201215123', '王敏', '女', '18', 'MA');
insert into student values('201215125', '张立', '男', '19', 'IS');
insert into student values('201215126', '欧阳风', '男', '20', 'ES