【正文】 system needs analysis, functional module division, database design and implementation, and systems used in technology are introduced Key words:Hotel Management Information System。 In response to these special circumstances the development of hotel management information system, the system uses and SQL Server 2020 as the development tools and database development tool. The main modules include: setting system management, housing management, consumption management, Information query, report management, data management, help system. First of all, design a short period of time to build a prototype system, and then a prototype of the system needs analysis, and we will continue to amend and improve until the line into the feasibility of the system. The difficulty lies in the system database design and dynamic connections between the modules。 本文 還 闡述了該系統(tǒng)的需求分析、功能模塊劃分、數(shù)據(jù)庫(kù)設(shè)計(jì)與實(shí)現(xiàn)，并就系統(tǒng)中用到的技術(shù)進(jìn)行了介紹 。本 系統(tǒng)的難點(diǎn)在于數(shù)據(jù)庫(kù)的設(shè)計(jì)和模塊之間的動(dòng)態(tài)連接。主要 模塊 包括 ： 系統(tǒng)設(shè)置管理、住房管理、消費(fèi)管理、信息查詢、報(bào)表管理、數(shù)據(jù)管、 系統(tǒng)幫助 。所以賓館需要一個(gè)適合自身情況的管理系統(tǒng)來(lái)管理賓館資源 。這種種情況，導(dǎo)致賓館的住宿管理十分紊亂。 畢 業(yè) 設(shè) 計(jì)（論 文） 賓館管理信息系統(tǒng)摘要 I 摘 要 賓館是接待往來(lái)客商的服務(wù)場(chǎng)所，其主要業(yè)務(wù)為提供住宿服務(wù)。由于客戶身份不一，來(lái)處去向均各有異，人員混雜，住宿時(shí)間亦有很大的變數(shù)。而過(guò)去傳統(tǒng)的純手工的管理方式，一來(lái)工作效率很低，二來(lái)很 難適應(yīng)日益增加的賓館規(guī)模。 針對(duì)上述情況特開(kāi)發(fā)賓館信息管理系統(tǒng)， 本系統(tǒng)使用 和 SQL Server 2020 作為程序開(kāi)發(fā)工具和數(shù)據(jù)庫(kù)開(kāi)發(fā)工具。設(shè)計(jì)首先在短時(shí)間內(nèi)建立起系統(tǒng)應(yīng)用的原型 , 然后對(duì)原型系統(tǒng)進(jìn)行需求分析 , 并不斷修正和改進(jìn) ，直到行成可行性系統(tǒng)。因?yàn)闀r(shí)間和能力的原因，目前本系統(tǒng)的設(shè)計(jì)為單機(jī)版 。 關(guān)鍵詞： 賓館管理信息系統(tǒng)； SQL Server 2020； II Abstract Hotel reception is the service places of business contacts, its core business of providing residential services. Due to different customer identification, where each has its own Office to different personnel mix, there is also a great time to stay variable. All these circumstances led to the management of hotel acmodation is disorder. In the past the traditional handmanagement, to a very low efficiency, and secondly it is difficult to adapt to the increasing size of the hotel. Therefore, the need for a hotel for their own management system to manage the hotel resources。 Because of the time and ability to reason, the current design of the system for standalone version。 SQL Server 2020。 第三章 系統(tǒng)需求分析 .................................................................................................................. 7 引言 ..................................................................... 7 項(xiàng)目概述 ................................................................. 7 具體功能需求 ............................................................. 8 系統(tǒng)設(shè)置管理子模塊 ............................................................................................. 8 住房管理子模塊 .................................................................................................... 9 系消費(fèi)管理子模塊 ................................................................................................ 9 系信息查詢子模塊 ................................................................................................ 9 報(bào)表管理子模塊 .................................................................................................... 9 數(shù)據(jù)管理子模塊 .................................................................................................... 9 版權(quán)管理子模塊 .................................................................................................. 10 數(shù)據(jù)庫(kù)要求 .............................................................. 10 性能需求 ................................................................ 10 第四章 系統(tǒng)功能設(shè)計(jì)與實(shí)現(xiàn) ..................................................................................................... 11 總體設(shè)計(jì) ................................................................ 11 賓館 管理 信息 需求規(guī)定 ....................................................................................... 11 運(yùn)行環(huán)境 ............................................................................................................ 11 人工處理過(guò)程 ..................................................................................................... 11 命名規(guī)范 ................................................................ 12 功能需求 ................................................................ 12 數(shù)據(jù)庫(kù)設(shè)計(jì) .............................................................. 13 確定數(shù)據(jù)庫(kù)中所需的表 ....................................................................................... 13 數(shù)據(jù)庫(kù)關(guān)系圖 ..................................................................................................... 13 數(shù)據(jù)庫(kù)的表的設(shè)計(jì) .............................................................................................. 14 設(shè)計(jì) 局部 ER模式 ............................................................................................... 15 IV 設(shè)計(jì)全局 ER模式 ............................................................................................... 17 數(shù)據(jù)字典 ............................................................................................................ 18 程序設(shè)計(jì) ................................................................ 22 程序描述 ............................................................................................................ 22 程序輸入設(shè)計(jì) ..................................................................................................... 22 程序輸出設(shè)計(jì) ..................................................................................................... 23 系統(tǒng)登陸管理界面設(shè)計(jì) ..................................................... 23 用戶登陸 ............................................................................................................ 23 系統(tǒng)主界面操作 .................................................................................................. 25 客房信息管理模塊 .............................................................................................. 25 用戶管理模塊 ..................................................................................................... 26 消費(fèi)物品信息管理模塊 ...........................