本文通過開發一個數據庫酒店客房管理系統,學習用Microsoft SQL Server 2000開發數據庫管理系統。采用Power Builder9.0等相關軟件為開發工具;通過對計算機硬件和軟件解決方案的論證;對應用領域進行調查分析;參考各種資料和進行數據庫編程實踐。在指導老師的幫助下,成功地實現了本系統主要的功能:預訂管理、入住管理、消費記賬管理和收銀退房管理,并能使設計的數據庫系統能夠實現一般所需要求的管理。
酒店客房管理系統主要是針對一般的酒店客房部作為單位使用對象而開發的,之所以把該系統定位如此之小,主要是考慮畢業設計題目不易過大,但考慮系統的完整性,仍然把它作為一個典型的信息管理系統(MIS)而設計。其系統開發任務主要包括數據庫的設計與維護、客戶端應用程序的開發等兩個方面。對于前者要求建立起的數據庫具有完整性和一致性,且具有一定的數據安全性如用戶需要密碼才能使用等,而對于后者則要求程序界面友好、功能完備等特點。經過詳細的分析,選用Power Builder9.0作為前端開發工具,利用其提供的集成開發環境及各種控件,尤其是對數據庫的良好支持完成對數據庫的各種操作,達到對酒店客房管理的目的。首先建立系統應用原型,然后對原型系統進行需求迭代,不斷修正和改進,直到形成用戶滿意的實際可行系統。
關鍵詞:數據庫; 信息管理系統(MIS); 完整性
Abstract
With the purpose to learn how to use Microsoft SQL Server 2000 and Power Builder9.0 to develop a hotel room database management system, I made a survey to study and analysis the current situation of small hotel in a small area of Jinhua city, so that more information about how rooms are used in these hotels can be learned. What’s more, I make sure that my solution of the database design can be worked from both computer hardware and software aspects. And with the help of various referenced information and practice of database programming, I have basically fulfilled the design task and I believe that my database can meet the needs of the database management.
Hotel room management system is mainly aimed at the general's hotel rooms as the unit of the developed object. Why the positioning of the system is so small lies on it is not appropriate to make the design is too large. In terms of the integrity of the system, it is still designed as a typical management information system (MIS). The main task of the system development including two aspects: database design and client applications. For the former requirement to establish a database with the integrity and consistency, and has a certain amount of data security strategy such as the users should need a password to login, while the latter requires user-friendly, full-featured application platform and so on. Power Builder9.0 chosen as the development tools has integrated development environment and a variety of controls, especially for a good support to database and completions of various operations on the database. Firstly, prototype the system, and then find iterative prototyping system, constantly revised and improved the database, until users are satisfied with the practical system.
Key words: Database;Management information system (MIS); Integrity