本文通过开发一个数据库酒店客房管理系统,学习用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