Design And Implementation Of Hotel Management System

With the rapid development of China's hotel industry in recent years, hotel industry becoming increasingly competitive. To improve the hotel's management level, to enhance the competitiveness of the hotel, advanced hotel management information system has become an inevitable choice for hotel operators. Due to a number of hotel services, guests content cumbersome, therefore often result in operation a lot of inconvenience and wasted time, reduced work efficiency, furthermore greatly affected the hotel's service quality and economic efficiency. To reduce costs, improve efficiency, service quality and management level, we must come to the aid of computer-assisted hotel management, and thus design the management system aim at these problems. The management system development, in line with scientific, standardized, systematic principles, and taking into account the actual situation of the hotel. The system supports SQL, with query convenience, security and good confidentiality, user friendly interface, easy to operate and so on. Apply this management system, the hotel not only can understand each guest's specific circumstances, but also in the guest information operations, saving a lot of time, to a large extent, improved the employee work efficiency and the hotel service quality.In this paper, hotel management system, detailed requirements analysis. The hotel system also discusses the detailed design process, including the hotel management system analysis, system functional design, database design, etc., this system development tools used in front of Visual Basic 6.0, back-end database development tool for Microsoft Access, front-end and back-end of A combination of ADO database access technology, and make use of OLAP technology realize the function of providing manager decision analysis,ultimately form a complete set of management information system.The system design is divided into fine main purpose of stages: the analysis phase: it described the main purpose of system development, to discuss the feasibility of the development, and carry out the main function of the system needed to complete demand analysis, defined the module data flow diagram; Overall design stages: base on discussion each functional module, carrying out the detailed database design, the system according to the functions of data management module is divided into order record module, accommodation management module, guest room management module, checkout management module, report management module,secretary reminding management module, decision analysis module and system management seven function modules; The detailed design stage: according to the structure of system, design the visual interface and the functional modules, such as system menu, the window object, the control button, the data window object etc; System coding phase: according to the contents of detailed design stage to coding the system, and according to the plans to develop a stable, reliable system; system test phase: testing the data management system, such as function, performance etc.