パフォーマンス考課システムデータベースsql serverコード

create database PEM;
use PEM;
create table Admin(
	adminId int identity(1,1) primary key,
	adminName varchar(255) not null,
	pswd varchar(255) not null,
	sex varchar (255) check(sex in(' ',' ')) not null
);

create table Department(
	depId int identity(1,1) primary key,
	depName varchar(255) unique not null,
	total int default 0
);

create table Employee(
	empId int identity(1,1) primary key,
	empName varchar(255) not null,
	pswd varchar(255) not null,
	sex varchar (255) check(sex in(' ',' ')) not null,
	depId int not null,
	foreign key (depId) references Department(depId) on delete cascade   on update cascade
);
create table Contact(
	empId int ,
	contact varchar(255),
	tel int not null,
	primary key(empId,contact),
	foreign key(empId)references Employee(empId) on delete cascade on update cascade
);
create table Test(
	testId int identity(1,1)primary key,
	testName varchar (255) unique not null,
	startTime datetime not null,
	endTime datetime not null