建表语句2.txt

图书管理系统 按书本上写的编辑的

教务管理

--------(表：学生)

use 教务管理
create table Student(
Sno int primary key not null,
Sname nvarchar (20) not null,
Sex char (2) check ( sex in('男','女')) null,
Age tinyint null,
Phone varchar (20) null,
)

--------(表：课程)

use 教务管理
create table Course(
Cno primary key char (50) not null,
Cname nvarchar (30) not null,
Credit tinyint not null check (Credit>=0 ), 
PCno char (5) null,
foreign key (Pcno) references Coure (Cno),
)

--------(表：选修)

use 教务管理
create table SC
(Sno int not null
Cno int not null
Score smallint null check ( Score>=0 and Score<=100 ),
primary key ( Sno , Cno ),
foreign key (Sno) references Students (Sno)
foreign key (Cno) references Course (Cno)
)





某公司内部管理

--------(表tblEmployees,存储员工的基本资料)

use 内部管理
create table tblEmployees(
empID primary key char (4) not null,
Name varchar (20) not null,
IDCardNum char (18) not null unique, 
Salary int not null check (Salary>=0) default '100',
)

--------(表tblDepartments,存储部门的信息)

use 内部管理
create table tblDepartments(
DeptID primary key char (2) not null,
DeptName varchar (30) not null,
)


--------(表tblWork,存储员工的工作记录)


use 内部管理
create table tblWork
(empID char (4) not null
DeptID char (2) not null
StartTime datetime not null dfault 'now'
EndTime datetime null check ( EndTime>StartTime ),
Notes vachar (1000) null,
primary key ( empID , DeptID , StartTime ),
foreign key (empID) references tblEmployees (empID)
foreign key (DeptID) references tblDepartments (DeptID)
)