最新数据库实验 学生宿舍管理系统设计大作业(9)

);

/*建立公寓楼基本信息表*/ CREATE Table Dormitory

(DorNo varchar(10) not null primary key, DorSex varchar(10) not null, DorMag varchar(50) not null, DorTel varchar(20) not null, DorNum varchar(20) not null, DorMax varchar(200) not null );

/*建立外来人员登记表*/

CREATE Table Live (StuNo varchar(8) not null primary key, StuName varchar(50) not null, DorNo varchar(20) not null, RNo varchar(60) not null, InTime varchar(8) not null,

foreign key (StuNo) references Student(StuNo), foreign key (DorNo) references Dormitory(DorNo)

);

/*建立楼栋工作人员基本信息表*/ CREATE Table Worker

( WorName Varchar(20) Not null, WorNo Varchar(20) Not null, WorSex Varchar(20) Not null, WorPhNo Varchar(20) Not null, WorType Varchar(20) Not null, WorWage Varchar(20) Not null, DorNo Varchar(20) Not null, Primary key(WorNo),

Foreign key(DorNo) References Dormitory (DorNo),Check(WorSex In('man','woman'))

);

/*建立来访记录信息表*/ CREATE Table Visit (

DorNo varchar(20) not null primary key, RNo varchar(20) not null,

InName varchar(20) not null, StuName varchar(20) not null, CTime varchar(20) not null, GTime varchar(20) not null,

Foreign key(DorNo) References Dormitory (DorNo) );