学生住宿管理系统(8)

学生住宿管理系统

primary key(WorNo),

foreign key(DorNo， DorCampus， DorLocation) references Dormitory(DorNo，DorCampus，DorLocation), check(WorWage >= 0),

check(WorSex = 男 or WorSex = 女 );

（2）宿舍楼基本信息表的建立：

create table Dormitory

DorNo smallint DorCampus char(4) DorLocation char(4) DorPhNo char(12)

not null, not null, not null, null,

DorAdminist char(10) null,

primary key(DorNo,DorCampus,DorLocation), check(DorNo>0 and DorNo<100);

（3）宿舍基本信息表的建立：

create table Room

RNo char(6) not null unique, RHeader char(10) null, RGrade char(4) not null, RDepart char(20) RPerfect char(20)

not null, not null,

DorNo smallint not null, DorCampus char(4) not null, DorLocation char(4) not null, primary key(RNo),

foreign key(DorNo， DorCampus， DorLocation) references Dormitory(DorNo，DorCampus，DorLocation);

（4）宿舍楼配备物品基本信息表的建立： create table Fitment

FitName char(16) not null unique,

FitPrice float FitNum int

not null, not null,

DorNo smallint not null, DorCampus char(4) not null, DorLocation char(4) not null, primary key(FitName),

foreign key(DorNo， DorCampus， DorLocation) references

Dormitory(DorNo，DorCampus，DorLocation);

（5）宿舍学生基本信息表的建立：

create table Student StuNo char(9)

not null unique, not null, not null, not null,

DepName char(20) StuName char(10) StuSex char(2)