文档介绍:use master
create database project
on
(
name = project,
filename='D:\'
)
go
use project
create table employee_info
(
Employee_no int primary key ,
Department_no int,
name varchar(20) not null,
sex char(2),
phonecode varchar(20),
[address] varchar(50)
)
go
create table project_info
(
project_no int primary key,
Department_no int,
Project_name varchar(20),
project_manager int
)
go
create table Department_info
(
Department_no int primary key,
name varchar(20),
Department_manager int
)
go
alter table employee_info
add constraint FK_Department_no foreign key(Department_no) references Department_info(Department_no)
go
alter table project_info
add constraint FK_proj_Department_no foreign key(Department_no) references Department_info(Department_no)
go
alter table project_info
add constraint FK_project_manager foreign key(project_manager) references employee_info(Employee_no)
go
alter table Department_info
add constraint FK_Dept_Department_manager foreign key (Department_manager) references employee_info(Employee_no)
go
insert into Department_info(Department_no,name)
select 1,'IPMS' union
select 2,'IEMS' union
select 3,'IBASE'
insert into employee_info
select 1,1,'张三','男','**********','A' union
select 2,3,'李四','女',null,'B' union
select 3,1,'王老五','男','1319