【文章內(nèi)容簡介】 功能模塊圖如下所示： 宿舍物品處理基本信息的查詢、更新功能模塊圖 宿舍保衛(wèi)處基本信息的查詢和更新模塊 將實現(xiàn)對宿舍保衛(wèi)處基本信息的查詢和更新（包括更改、插入、刪除）操作，方便于宿舍意外事故的處理，具體的功能模塊圖如下： 宿舍樓保衛(wèi)處基本信息的查詢、更新功能模塊圖5．數(shù)據(jù)庫實施階段、數(shù)據(jù)表、視圖、索引 建立數(shù)據(jù)庫 create database Student_Dormitory_Management。 建立數(shù)據(jù)表（1）樓道工人基本信息表的建立：create table Worker（WorNo char(5） not null unique,WorName char(10) not null,WorType char(8) not null,WorWage int not null,WorSex char(2) not null,WorPhNo char(12) null,WorTime char(30) null,DorNo smallint not null,DorCampus char(4) not null,DorLocation char(4) not null,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 not null,DorCampus char(4) not null,DorLocation char(4) not null,DorPhNo char(12) null,DorAdminist char(10) null,primary key(DorNo,DorCampus,DorLocation),check(DorNo0 and DorNo100))。（3）宿舍基本信息表的建立：create table Room(RNo char(6) not null unique,RHeader char(10) null,RGrade char(4) not null,RDepart char(20) not null,RPerfect char(20) 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 not null,FitNum int 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）宿舍學(xué)生基本信息表的建立：create table Student( StuNo char(9) not null unique, DepName char(20) not null, StuName char(10) not null, StuSex char(2) not null, StuHome char(10) not null, StuBorth Datetime not null, StuETime Datetime not null, StuPerfect char(20) not null, StuClass int not null, RNo char(6) not null, DorNo smallint not null, DorCampus char(4) not null, DorLocation char(4) not null, primary key(StuNo), foreign key(RNo) references Room(RNo),foreign key(DorNo， DorCampus， DorLocation) references Dormitory(DorNo，DorCampus，DorLocation), check(StuClass0 and StuClass=10))。（6）宿舍保衛(wèi)處基本信息表的建立：create table SafeGuard( SGName char(15) not null unique, SGWorNum int not null, SGHeader char(10) not null, SGPhone char(12) null, primary key(SGName), check(SGWorNum 0))。（7）宿舍樓物品出入基本信息表的建立：create table ArticalInOut( StuNo char(9) not null, AIOArtical char(16) null, AIOPrin char(9) not null,AIODate datetime not null,AIONo int not null unique,DorNo smallint not null,DorCampus char(4) not null,DorLocation char(4) not null,primary key(AIONo,AIODate),foreign key(StuNo) references Student(StuNo),foreign key(AIOPrin) references Worker(WorNo),foreign key(DorNo， DorCampus， DorLocation) references Dormitory(DorNo，DorCampus，DorLocation),check(AIONo 0))。（8）宿舍配備物品損壞基本信息表的建立：create table FitmentDestruction( FitName char(16) not null unique, StuNo char(9) not null, RNo char(6) not null, FDFitNum int not null, DorNo smallint not null,DorCampus char(4) not null,DorLocation char(4) not null,foreign key(DorNo， DorCampus， DorLocation) references Dormitory(DorNo，DorCampus，DorLocation), foreign key(FitName) references Fitment(FitName), foreign key(StuNo) references Student(StuNo), foreign key(RNo) references Room(RNo), check(FDFitNum = 0))。（9）宿舍損壞配備物品賠償基本信息表的建立：create table FitmentCompensate( FitName char(16) not null, StuNo char(9) not null, FCPrin char(15) not null, FCompDate Datetime not null, FCompNum int not null, foreign key(FitName) references Fitment(FitName), foreign key(StuNo) references Student(StuNo), foreign key(FCPrin) references SafeGuard(SGName), check(FCompNum = 0))。（10）宿舍事故注冊基本信息表的建立：create table Accident( AcNo int not null unique, AcType char(10) not null, StuNo char(9) not null, AcDate datetime not null, AcArtical char(30) not null, AcVerify bool null, SGName char(15) not null, AcArNum int not null, AcStuPh char(12) not null, primary key(AcNo,AcDate), foreign key(StuNo) references Student(StuNo), foreign key(SGName) references SafeGuard(SGName), check(AcArNum 0),)。（11）宿舍事故調(diào)查基本信息表的建立：create table AccidentResearch( AcNo int not null, ARName char(15) not null, SGName char(15) not null, ARResult bool not null, primary key(SGName), foreign key(AcNo) references Accident(AcNo), foreign key(SGName) references SafeGuard(SGName),)。（12）宿舍事故賠償基本信息表的建立：create table AccidentCopensate( AcNo int not null, ACStu char(9) not null, AcArtical char(30) not null, AcDate Datetime not null, SGName char(15) not null, foreign key(AcNo) references Accident(AcNo), foreign key(ACStu) references Student(StuNo), foreign key(SGName) references SafeGuard(SGName))。 建立視圖 （1）用于查詢和更新樓道工人基本信息的視圖定義如下： create view WorView(編號，姓名，工作類型，工資，性別，聯(lián)系方式， 工作時間，宿舍樓編號，校區(qū)，區(qū)位) as select * from Worker with check option。 （2）方便于宿舍樓基本信息查詢、更新的視圖定義如下： create view DormView (宿舍樓編號，校區(qū)，區(qū)位，樓管處電話，樓管) as select * from dormitory with check option。 （3）顯示宿舍基本信息的視圖定義如下： create view RoomView (宿舍編號，舍長，年級，學(xué)院，專業(yè)，宿舍樓編號， 校區(qū)，區(qū)位) as select * from Room with check option。 （4）可用于宿舍樓配備物品基本信息查詢、更新的視圖定義如下： create view FitView (物品名，價格，數(shù)量，宿舍樓編號， 校區(qū)，區(qū)位) as select * from Fitment with check option。 （5）用于查詢和更新學(xué)生基本信息的視圖定義如下： create view StuView (學(xué)號，學(xué)院，姓名，性別，祖籍，出生日期，入學(xué)時間， 專業(yè)，班級，宿