http://weiyipeerless.blog.163.com/
- 数据库建立
create database 名字
- 数据库建表(有级联删除功能)
--学院
create table college
(
clgname varchar(10) primary key
)
--班级
create table class
(
clsname varchar(10) primary key,
clgname varchar(10) not null foreign key references college(clgname)
on delete cascade
on update cascade
)
--学生
create table student
(
stuid int identity(1,1),
stuname varchar(10) not null,
stuentrytime datetime not null,
clsname varchar(10) not null foreign key references class(clsname)
on delete cascade
on update cascade
)