did you teach it by teacher Huang chunyi?
I'll provide you with a hotel room management system. I can't paste a table and drink a flow chart. There's nothing I can do.
--------------------------
There are many more to post.
the first chapter is about
with the development of social economy, people's requirements for quality of life are getting higher and higher, and the hotel industry, as one of the services, is constantly improving its service system. It is a three-dimensional service system integrating catering, accommodation and entertainment, in which customers can spend at will and settle accounts uniformly; Hotel managers can keep abreast of all the hotel operations and trends, and find out the operating costs as the basis for business decisions. Only by using advanced scientific management means and computer management system can this management mode be better realized. [1 [1]
§1.1 Topic Background
In recent years, the hotel industry has developed rapidly and the market competition has become increasingly fierce. It has become an urgent task for the hotel industry to comprehensively improve its software management level. Especially for star-rated hotels, it is necessary to complete some services at the front desk and management at the back desk. However, the traditional manual management mode is far from meeting the needs of dealing with a large amount of information and data generated in business effectively and quickly, which makes the decision-makers of enterprises unable to grasp the first-line information in time and accurately, and then affects the correct analysis and prediction of the market. For example, three-star hotels in coastal cities have introduced foreign management, making the management level of a small number of hotels almost close to or reach the international level. However, it is difficult for the majority of small and medium-sized hotels, which account for more than 81%. Therefore, if you want to get rid of your competitors and gain an advantage in the competition, you must be unique in management, management, products and services. The management of guest rooms plays a decisive role in the operation of hotels. Simple service standards are no longer the key to success. Only the most subtle management can make customers realize the high standards and high quality of hotel services, and accuracy, speed and comprehensiveness are often the most basic elements of success.
Traditional management methods can no longer meet the needs of modern society, so it has become a prerequisite to promote the rapid development of the hotel industry to use computers to manage business, finance and many other links. The hotel room management information system is a management system that all large, medium and small hotels need to use.
1.2 Significance of topic selection
In the rapidly developing information age, information has become a key resource for all enterprises. Hotel room management information system is a computer application system which is used to collect, process, store and disseminate information about rooms, customers and settlement, and takes information management as the core. The reasonable database structure in the hotel room management information system is used to save data information, keep abreast of the changes of information in each link, and support the execution of various data operations through effective program structure, so as to improve management efficiency and realize the systematization, standardization and automation of hotel services. Through the development and use of this project, hotels can improve the management and operation efficiency of hotels, improve service quality, save expenses and improve labor productivity. [2] thus winning high reputation, strong strength and good benefits!
1.3 overall goal
To establish a set of fully functional management information system, which can not only meet the daily processing needs of business personnel, but also enhance the digital management level of the whole business process; It can also meet the needs of managers' decision analysis and improve the response speed of the company's management to the company's business feedback information. Therefore, the work efficiency is greatly improved, the accuracy and scientificity of management are improved, and the management staff are freed from the complicated manual work.
* Quickly realize the check-in registration and accounting treatment of guests, and reduce the waiting time of guests when staying in and leaving the hotel
* Accurately realize the requirements of guests' booking, and realize the effective and guaranteed front desk system operation
* Quickly respond to the relevant project inquiry requirements of guests
* Realize the one-stop service of check-in, consumption and checkout. Various consumption requirements for the convenience of guests in the store
Chapter II Analysis of Hotel Room Management System
System analysis is to decompose complex objects into simple components by using systematic ideas and methods, and find out the basic attributes of these parts and their relationships. In view of the problems existing in the current hotel room computer management system, in order to improve the rapidity and accuracy of information collection, the special functions of the computer are used to process a large number of complex data in the hotel room management system, and all kinds of management information and business information are output in time, which provides a strong basis for effective management and decision-making of personnel at all levels, improves work efficiency and economic benefits, and puts forward the overall logical description of the system on the basis of comprehensive investigation.
Preliminary investigation of 2.1 system
In today's highly developed information, all work links involved in the hotel service industry are no longer just traditional accommodation and settlement, but broader and more comprehensive service industry representatives. As a service industry, a hotel should be able to take guests as the center, provide fast and convenient service, improve the management level of the hotel, simplify various complicated operations, and complete the standardized operation of the hotel business in the most reasonable and shortest time, so as to make customers comfortable and unforgettable and increase the customer return rate. Facing the fierce competition in the hotel industry, hotels are striving to expand the breadth and depth of their service areas. Information system has a wide range of practical applications. [3] Although the computer is not the key factor for the success of the hotel, it can help those factors that really affect the success or failure to play a greater role. Therefore, adopting a brand-new computer management system will become one of the important means to improve the management efficiency and service level of hotels.
According to the statistical analysis of China's hotel industry,
In the modern hotel service industry, due to the growth of customer flow, traditional management methods make office workers have to deal with many things every day, and repetitive work makes them inefficient; All kinds of customer information collection is not complete; The classification and filing are unreasonable, which makes it difficult to find; The unscientific preservation method makes the data and documents damaged, which affects the use effect and time.
In view of this situation, hotel managers have realized the importance of using computer management information system, so they urgently need to develop a "hotel room management information system" for management.
Feasibility analysis of 2.2 system
Based on the specific situation of the hotel, after various investigations and discussions, the hotel room management information system has met the basic conditions for implementation from the technical, economic and management aspects:
2.2.1 Technical feasibility
The stability and security of WIN2111/NT/XP operating system can meet the requirements of users. In the development of database application system, efficient database access is the constant pursuit goal of developers, and SQL is the shortcut to achieve this goal. The database in the background uses SQL Server, and the development tool chooses PowerBuilder8.1 of Sybase company, which has good upgrade potential and maintainability. These softwares have been widely used in the development of large-scale MIS, and they are mature in technology. They can easily add or subtract modules according to users' needs, with intuitive graphical user interface and concise operation flow, and can be used quickly without professional computer knowledge. [4] Therefore, it is technically feasible.
2.2.2 economic feasibility
cost: the computer configuration required by this system is not high (processors above 411M Hz). 64M memory and above, hard disk space more than 111M), the installation and debugging of equipment is simple, the price of PB software is not high, the operation is simple, and users can skillfully use this system with a small amount of training, so the training cost is low.
benefits: after the hotel front desk uses this system, the checking efficiency is improved and the relative errors are greatly reduced; That is, the working efficiency of the staff is greatly improved and the working time is greatly saved, thus indirectly creating considerable economic benefits for the hotel, reducing the expenditure of management expenses and avoiding unnecessary human errors; It also improves the quality of staff, is conducive to the reasonable reform of management methods and systems, and ensures the sustainable development of hotel room management. Therefore, it is economically feasible.
2.2.3 Management Feasibility
Establishing a management information system is an inevitable requirement for the development of the industry, and hotel leaders attach great importance to the management of science and technology. Informatization of management and business processes is the first step in the modernization of management information. And employees have shown great enthusiasm and expectation for this. Because the implementation of this system will greatly reduce their manual work, reduce their mistakes in work and improve work efficiency. Therefore, this system is feasible in management.
2.3 Detailed investigation
The requirement of developing this system comes from the dissatisfaction with the original traditional management mode, whether it is a manual system or a running computer system. Because of the problems in all aspects, the content is scattered and even vague, this requires the author to make a detailed analysis and put forward a system development plan on the basis of the original management model. This system is a virtual management information system, and there is no original operating system.
2.3.1 organization chart
According to the investigation and analysis, the housekeeping department of small and medium-sized hotels in China is composed of housekeeping manager, front desk foreman, assistant manager of lobby, lobby foreman, telephone operator, business center foreman and room service group. That is, the organization chart is shown in Figure 2.1:
Figure 2.1 Organization chart
2.3.2 Business process analysis
Business process analysis is a further refinement of business function analysis, and the result of business process analysis is a business flow chart. The business flow chart reflects the actual business activities. It is not only the basis for system analysts to conduct more in-depth system analysis, but also a communication tool for system analysts, managers, business operators and system designers. [5] You can directly draw up the part that can be realized by computer on the business flow chart, clarify the boundary of the system, make the interface between computer processing and manual business processing clear, analyze whether the business process of the organization is reasonable, delete repeated and unreasonable links, and clarify the whole business process, laying a good foundation for future analysis and design.
Therefore, in order to reflect the degree of contact between departments in the hotel, their main business and the work they undertake in the business process. The business flow chart of the hotel is as shown in Figure 2.2:
Inquire
Choose a room
Confirm the hand card
Set up an account
Figure 2.2 Business flow chart
Analyze the current system through the current business flow chart, which shows that there are many guests and many services needed, resulting in poor control and low efficiency in the management process. Some business of the front desk operator can be realized by computer, which can improve efficiency and reduce the workload of people.
The job of this system is to change the traditional management mode into man-machine interactive operation. From the above analysis, the boundary of the system can be clearly defined, and unnecessary manual operations can be deleted from the system. First of all, you can query the room status on the computer to know the occupancy of the room, which can reduce the query time for the staff and improve the management efficiency. In addition, guests can reserve rooms, thus avoiding the trouble of finding temporary accommodation in the local area, saving time for guests, improving work efficiency and bringing certain economic benefits to the hotel. If the guest is an individual, register at the front desk and check in. If the guest's deposit is insufficient, the hotel staff can remind him to pay the deposit. If he has some temporary expenses, he can check out or check out together when he leaves the hotel. It improves the management efficiency of the hotel, makes the organizational structure of the hotel develop in a flat direction, and does as much work as possible with the least manpower and material resources.
comparison and demonstration of 2.4 system scheme
proposal of 2.4.1 system scheme
1, C/S system: (scheme 1)
(1)C/S system description
C/S system is client/server mode, and the client is developed by PowerBuilder and runs on the operating system of Windows2111. The server-side software runs on Windows2111 Server; The database adopts SQL SERVER.
(2) Design of C/S mode
The hotel room management system adopts C/S mode, which stores all kinds of information of customer resources on the server side, and the operator can operate and check the operation database on the client side. Each client is connected to the server.
(3) Developing the running environment
Running environment:
a.CPU: minimum 411 MHz
B. Memory: 64m
C. Input and output devices: keyboard, Mouse
hard disk space above p>d.111M
E. Operating system: Microsoft Windows 2111
F. Development tool: PowerDesigner
G. Development language: PowerBuilder+SQL Server
2. B/S system (scheme 2)
(1)B/S system.
(2) Developing the running environment
Running environment:
a.CPU: minimum 411 MHz
B. Memory: 64m
C. Input and output devices: keyboard, Mouse
D. Browser IE5.1 or above
E. Operating system: Microsoft Windows 2111+IIS 5.1
F. Development tool: Dreamweaver
G. Development language: JSP
§2.4.2 Comparison of system schemes
Scheme 1 (C/S mode) Scheme 2. S-mode)
The hardware environment is built on a special network. The network environment in a small area and the local area network provide connection and data exchange services through a special server, which is built on the wide area network. It is not necessary to be a special network hardware environment, such as telephone access and renting equipment. Information management itself
The security requirements are oriented to a relatively fixed user group, and the information security control ability is very strong. The ability to control security is relatively weak, and the C/S program is oriented to an unknown user group.
The program architecture can pay more attention to the process, can check the authority at multiple levels, and can give less consideration to B/S's multiple considerations of security and access speed for the running speed of the system. It is based on the need for more optimization.
The C/S user interface is fixed, and in the same area, the security requirements are high, so they should all be the same system. B/S is based on WAN, facing different user groups, scattered in different regions, and has little relationship with operating system platform
User interface is mostly based on Window platform and browser
The response speed can give full play to the client.