酒店信息管理數(shù)據(jù)庫設(shè)計(jì)需求分析酒店信息管理數(shù)據(jù)庫是一種用來管理酒店樓層、客房、入住，賬單、會(huì)員信息。針對設(shè)計(jì)規(guī)定設(shè)計(jì)如下數(shù)據(jù)構(gòu)造樓層信息，涉及數(shù)據(jù)有Floorid、Floorname?？头款愋托畔?，涉及數(shù)據(jù)有：TypeID、Typename、Price、CombinPrice、OverdestineNum、Combination?？头啃畔⒈?，涉及數(shù)據(jù)有：RoomID、FloorID、TypeID、GuestNumber、BedNumber、RoomDesc、Memo、State入住單信息表，涉及數(shù)據(jù)有：CheckInID、VIPID、TypeID、TypeID、TypeID、LeaveTime、BillState、CheckInNumber、RoomID、CheckinPrice等。賬單明細(xì)表，涉及數(shù)據(jù)有：AccountID、CheckInID、ConsumeContent等。預(yù)定表，涉及數(shù)據(jù)有：CheckInID、VIPID、TypeID、ArriveTime、LeaveTime、BillState等。會(huì)員表，涉及數(shù)據(jù)有：VIPID、Name、Job、Phone、E-mail、Memo。概念構(gòu)造設(shè)計(jì)根據(jù)設(shè)計(jì)表規(guī)定，理解到該數(shù)據(jù)庫涉及客房、賬單、會(huì)員客戶。通過度析，畫出了酒店關(guān)系旳E-R圖，分別如下：Floorid樓層FloornameFloorid樓層FloornameeCombinPriceTypeID圖1、樓層關(guān)系E-R圖CombinPriceTypeID客房類型客房類型OverdestineNumTypenameOverdestineNumTypenameCombinationCombinationPrice圖2客房類型E-R圖StateMemoRoomIDMemoRoomIDFloorID客房信息RoomDescFloorID客房信息RoomDescTypeIDTypeIDBedNumberBedNumberGuestNumberGuestNumber 圖3客房信息E-R圖CheckInNumber……CheckInNumber……CheckInIDCheckInIDBillState入住單BillState入住單VIPIDVIPIDLeaveTimeLeaveTimeTypeIDTypeIDArriveTimeArriveTime 圖4入住單E-R圖ConsumeMoneyAccountIDConsumeMoneyAccountIDConsumeTime賬單明細(xì)ConsumeTime賬單明細(xì)CheckInIDCheckInIDMemoMemoConsumeContentConsumeContent圖5賬單明細(xì)E-R圖ArriveTimeCheckInIDArriveTimeCheckInIDLeaveTime預(yù)定表LeaveTime預(yù)定表VIPIDVIPID…………TypeIDTypeID圖6預(yù)定表E-R圖PhoneVIPIDPhoneVIPIDE-mail會(huì)員表（VIP）E-mail會(huì)員表（VIP）NameNameMemoMemoJobJob圖7會(huì)員表E-R圖通過對個(gè)實(shí)體之間聯(lián)系旳分析，將局部E-T圖綜合成全局E-R圖屬于樓層入住單預(yù)訂單屬于樓層入住單預(yù)訂單 屬于屬于屬于屬于屬于屬于屬于屬于客房類型會(huì)員表客房類型會(huì)員表賬單明細(xì)賬單明細(xì)屬于屬于客房信息客房信息邏輯構(gòu)造設(shè)計(jì)根據(jù)概念設(shè)計(jì)旳成果,將其轉(zhuǎn)換為關(guān)系模型：樓層（Floorid、Floorname）；客房類型（TypeID、Typename、Price、CombinPrice、OverdestineNum、Combination）；客房信息（RoomID、FloorID、TypeID、GuestNumber、BedNumber、RoomDesc、Memo、State）；入住單（CheckInID、VIPID、TypeID、ArriveTime、LeaveTime、BillState、CheckInNumber、RoomID、CheckinPrice、Discount、DiscountReason、AddBed、Earnest、DestMan、DestCompany、Phone、Operator、Memo、AmountRece、ConsumeMoney、AccountState、AccountTime、PayMode）；賬單明細(xì)（AccountID、CheckInID、ConsumeContent、ConsumeMoney、ConsumeTime、Memo）；預(yù)訂單（CheckInID、VIPID、TypeID、ArriveTime、LeaveTime、BillState、CheckInNumber、RoomID、CheckinPrice、Discount、DiscountReason、AddBed、Earnest、DestMan、DestCompany、Phone、Operator、Memo）；會(huì)員表（VIPID、Name、Job、Phone、E-mail、Memo）；物理構(gòu)造設(shè)計(jì)FloorInfo字段名類型闡明功能FlooridInt非空，主鍵樓層編號FloornameChar（3）字段名類型闡明功能TypeIDInt非空，主鍵類型編號Typename類型名稱PriceMoney價(jià)格CombinPriceMongey拼房價(jià)格OverdestineNumInt可超預(yù)定數(shù)CombinationBit與否可以拼房GuestRoomInfo字段名類型闡明功能RoomIDInt非空，主鍵客房編號FloorIDInt非空，外鍵樓層編號TypeIDInt非空，外鍵類型編號GuestNumberInt不小于0額定人數(shù)BedNumberInt不小于0床數(shù)RoomDescVarchar（40）客房描述Memo備注StateVarchar（4）默認(rèn)值為“無人住”狀態(tài)CheckInBill字段名類型闡明功能CheckInIDInt非空，主鍵，標(biāo)記列入住單編號VIPIDInt非空，外鍵會(huì)員編號TypeIDInt非空，外鍵客房類型ArriveTimeDatetime達(dá)到時(shí)間LeaveTimeDatetime離開時(shí)間BillStateVarchar(20)單據(jù)狀態(tài)CheckInNumberint入住人數(shù)RoomIDint非空，外鍵客房編號CheckinPriceMoney入住價(jià)格DiscountFloat折扣DiscountReasonVarchar(20)折扣因素AddBedBit與否加床EarnestMoney預(yù)收款DestManVarchar（20）預(yù)定人DestCompanyVarchar（60）預(yù)定公司PhoneVarchar（15）聯(lián)系電話OperatorVarchar(10)操作員MemoVarchar（50）備注AmountReceMoney應(yīng)收賬款ConsumeMoneyMoney消費(fèi)金額AccountStateBit與否結(jié)賬AccountTimeDatetime結(jié)賬日期PayModeVarchar（20）付款方式賬單明細(xì)表BillDetail字段名類型闡明功能AccountIDInt非空，主鍵賬單編號CheckInIDInt非空，外鍵入住單編號ConsumeContentVarchar（40）消費(fèi)內(nèi)容ConsumeMoneyMoney消費(fèi)金額ConsumeTimeDatetime消費(fèi)時(shí)間Memo備注BookingList字段名類型闡明功能CheckInIDInt非空，主鍵，標(biāo)記列入住單編號VIPIDInt非空，外鍵會(huì)員編號TypeIDInt非空，外鍵客房類型ArriveTimeDatetime達(dá)到時(shí)間LeaveTimeDatetime離開時(shí)間BillStateVarchar(20)單據(jù)狀態(tài)CheckInNumberint入住人數(shù)RoomIDint非空，外鍵客房編號CheckinPriceMoney入住價(jià)格DiscountFloat折扣DiscountReasonVarchar(20)折扣因素AddBedBit與否加床EarnestMoney預(yù)收款DestManVarchar（20）預(yù)定人DestCompanyVarchar（60）預(yù)定公司PhoneVarchar（15）聯(lián)系電話OperatorVarchar(10)操作員MemoVarchar（50）備注會(huì)員表VIP字段名類型闡明功能VIPIDInt非空，主鍵會(huì)員編號NameVarchar（10）會(huì)員姓名JobVarchar（40）單位PhoneVarchar（15）長度不小于等于11聯(lián)系電話E-mailVarchar（20）必須