淺談小區(qū)物業(yè)管理數(shù)據(jù)庫(kù)設(shè)計(jì)(編輯修改稿)
2025-05-09 22:43 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 數(shù)據(jù)庫(kù)，基本表，視圖，索引，觸發(fā)器以及存儲(chǔ)過(guò)程主要包括：數(shù)據(jù)庫(kù)、基本表、視圖、索引、觸發(fā)器以及存儲(chǔ)過(guò)程；（1）建立數(shù)據(jù)庫(kù)：Create database PropertyManagement（2）建立基本表：共有7張基本表，具體SQL語(yǔ)句見(jiàn)附錄2（3）建立視圖：共有7個(gè)視圖，具體SQL語(yǔ)句見(jiàn)附錄2（4）建立索引：共有2個(gè)索引，具體SQL語(yǔ)句見(jiàn)附錄2（5）建立觸發(fā)器：共有2個(gè)觸發(fā)器，具體SQL語(yǔ)句見(jiàn)附錄2（6）建立存儲(chǔ)過(guò)程：共有？個(gè)存儲(chǔ)過(guò)程，具體SQL語(yǔ)句見(jiàn)附錄2系統(tǒng)包括物業(yè)設(shè)備管理、停車(chē)場(chǎng)管理、維修管理、收費(fèi)管理五個(gè)功能模塊，共有7張基本表, 采用的是多條記錄EXCEL批量導(dǎo)入,然后使用SQL Server 2008數(shù)據(jù)導(dǎo)入/導(dǎo)出功能,直接將數(shù)據(jù)導(dǎo)入到相應(yīng)的基本表中。數(shù)據(jù)的測(cè)試主要是通過(guò)查詢(xún)、插入、刪除、修改操作來(lái)完成的，具體見(jiàn)附錄3。6．總結(jié)*****7．附錄附錄1業(yè)務(wù)流程圖附錄2 數(shù)據(jù)庫(kù)的建立附錄2. 1—1Create table Administrator( AdminNo char(20) primary key not null, AdminName char(20) not null, AdminSex char(2) check(AdminSex=39。男39。 or AdminSex=39。女39。) not null, ManageItem char(20) not null, AdminPhone char(20) not null)。附錄2. 1—2Create table RoomOwner( RNo char(20) primary key not null, OwnerName char(20) not null, OwnerSex char(2) check(OwnerSex=39。男39。 or OwnerSex=39。女39。) not null, OwnerPhone char(20) not null, CheckInTime char(20) not null)。附錄2. 1—3Create table RepairManagement( RepNum char(20) Primary key not null, RTimes int check(RTimes0 and RTimes9999)not null, RNo char(20) not null, OwnerName char(20) not null, AdminNo char(20) not null, RTime date, Rcost int not null, Foreign key (Rno) References RoomOwner(RNo), Foreign key (AdminNo) References Administrator(AdminNo))。附錄2. 1—4Create table ParkManagement( ParkNo char(20) Primary key not null, RNo char(20) not null, PStartTime date, PEndTime date, AdminNo char(20) not null, PCharge int not null, Foreign key (Rno) References RoomOwner(RNo), Foreign key (AdminNo) References Administrator(AdminNo))。附錄2. 1—5Create table Equipment( EquNo char(20) primary key not null, EquName char(20) not null, ELendTime date not null, ERetTime date not null, AdminNo char(20) not null, Rno char(20) not null, Foreign key (Rno) References RoomOwner(RNo), Foreign key (AdminNo) References Administrator(AdminNo))。附錄2. 1—6Create table ChargeManagement( Cno1 char(20) Primary key not null, Cname char(20) not null, CStartTime date, CEndTime date, Cused int not null, CPrice int not null, AdminNo char(20) not null, Rno char(20) not null, Foreign key (AdminNo) References Administrator(AdminNo), Foreign key (Rno) References RoomOwner(RNo))。附錄2. 1—7Create table Charge( Cno2 char(20) Primary key not null, Cname char(20) not null, CCharge int not null, CTime date not null, CStatus char(2) check(CStatus = 39。是39。 or CStatus = 39。否39。) not null, Rno char(20) not null, Foreign key (Rno) References RoomOwner(RNo))。附錄2. 2—1create unique index AdNo on Administrator(AdminNo)。附錄2. 2—2create unique index RoomNo on RoomOwner(RNo)。附錄2. 3—1Create View AdminView(AdminNo,AdminName,AdminSex,ManageItem,AdminPhone)AsSelect *From Administratorwith check option附錄2. 3—2Create View ROView(RNo,OwnerName,OwnerSex,OwnerPhone,CheckInTime)AsSelect *From RoomOwnerwith check option附錄2. 3—3Create View ParkView(ParkNo,Rno,PStartTime,PEndTime,AdminNo,PCharge)AsSelectParkNo,PStartTime,PEndTime,PChargeFrom ParkM
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1