注意:
1 填空题在需要写的SQL语句后不写";"号
2 如若数据库服务器上有wchst2数据库请删除该库
3 将以下内容复制到查询分析器中运行.
----复制开始
create database wchst2
go
use wchst2
go
create table student (
sno char (9) primary key ,
sname char (20) not null ,
ssex char (2) null ,
sage smallint null ,
sdept char (20) null
)
go
create table course (
cno char (4) primary key not null ,
cname char (40) null ,
cpno char (4) null ,
ccredit smallint null ,
foreign key (cpno) references course (cno)
)
go
create table sc (
sno char (9) not null ,
cno char (4) not null ,
grade smallint null ,
primary key (sno,cno) ,
foreign key (cno) references course (cno),
foreign key (sno) references student (sno)
)
go
delete from sc
go
delete from student
go
delete from course
go
insert into student values('200215101','崔深梁','女',17,'MA')