Urgent for graduation thesis of hotel management system.

Design outline

Quote 2

I. System design process 3

1. 1 system design step 3

1.2 functional module division 3

Second, the characteristics of the system 4

Three. System operating environment 4

3. 1 system operating environment 4

3.2 vb overview 5

3.3 Introduction to SQL Database 5

Fourth, the system function realization 6

4. 1 database design 6

4. 1. 1 database file 6

4. 1.2 database design 7

4.2 Interface Design 8

4.3 Customer Management Module Design 9

4.3. 1 customer registration 1 1

4.3.2 Check-out settlement 12

Verb (abbreviation of verb) summary 13

Reference 13

Attachment: Program 14

Development of Hotel Management System

Modern hotel is a consumer place that integrates services and facilities such as guest rooms, catering, communication, entertainment, business culture, etc. The hotel has a huge organization, many services and a large amount of information. In order to improve labor productivity, reduce costs, improve service quality and management level, and promote economic benefits, modern information management must be carried out with the help of computers. This design is based on the characteristics of hotels, small and medium-sized hotels and hotels, and develops a set of software systems suitable for hotels, small and medium-sized hotels and hotels.

Keywords: hotel management system development

In recent years, with the accelerated pace of reform and opening up and the exchange and development of Chinese and Western cultures, the living standards of the people in China have improved significantly, and the demand of the whole society for the catering industry has also increased. With the continuous growth of consumption, the hotel industry has become one of the fastest growing industries in modern society. In order to survive in the fierce market competition, we must improve our management awareness in business management and catering services. The management of hotel daily business plays a decisive role in hotel management.

How to use advanced management methods to improve the management level of hotels is an important topic faced by every hotel operator. Therefore, the hotel management system has good practical application value. People have been using traditional manual methods to manage bills. This management method has many shortcomings, such as low efficiency and poor confidentiality. In addition, a large number of documents and data will be produced after a long time, which brings great difficulties to search, update and maintenance, and also increases the workload and work difficulty of managers. The system overcomes these shortcomings well, and has the advantages of fast retrieval, convenient search, high reliability, large storage capacity, good confidentiality, long service life and low cost.

These advantages can greatly improve the efficiency of hotel management, which is also an important condition for hotel management to be scientific, standardized and in line with the world. The system takes Microsoft SQL Server 2000 as the background database, Visual Basic 6.0 as the foreground development tool, and adopts the modular structure design idea of top-down layer-by-layer decomposition and object-oriented design method to complete the main modules of the hotel management system. Nowadays, with the continuous development of economy, the business volume of hotel market brought by traveling abroad has greatly increased. In this way, a series of data such as room management and check-in can be imported and exported. Most dealers only use simple Office Excel to record, so it is inconvenient to query and record. If we design a special software for hotel managers and hotel employees to query hotel information, as well as all kinds of reservations, check-in, check-out, settlement and check-out, it will greatly reduce the work of sellers and increase hotel turnover. At the same time, in order to strengthen the management of customers and employees, we developed a hotel management system for a hotel, which solved the complex and irregular management problems of the hotel, optimized the management process and realized the paperless office of hotel management.

First, the system design process

1. 1 system design steps

According to the relevant rules and regulations and management process of our school, our team first established a management model by using rapid prototype programming coding method. After full communication with the school instructor, the model was optimized and improved, and the original workflow was transformed. Because of the use of Microsoft Visual Basic 6.0 programming, modeling and code writing are almost synchronous, which greatly improves the efficiency.

1.2 functional module division

1. Customer management

Customer management refers to the centralized recording and modification of customer information by administrators, which can improve work efficiency and customer information processing by managing customer information.

2. Room management

Room management means that the administrator should know the status of the hotel room in time, such as whether the hotel room is vacant, under maintenance or reserved.

3. Customer inquiries

Customer query is the administrator's search for customer information, which is divided into fine query and fuzzy query. In the refined query, the customer's address, customer number, ID number and room number are also divided into customer name query and customer workload query.

4. Management personnel

The administrator is responsible for managing the information of the system. Administrators can modify, add and delete system information. It is not a single administrator. There are multiple administrators, but administrators who enter the system can delete and add administrators inside the system.

Second, the characteristics of the system

1. After the software is completed, it greatly improves the efficiency of the hotel in handling the basic ordinary work of checking in, checking out and booking for new guests in advance.

2. The software is easy to learn and use, simple to operate and wide in application.

3. This system has powerful query function.

4. Back up and separate the database manually to prevent data loss.

Third, the system operating environment.

3. 1 system operating environment

1, hardware environment

○ 1CPU frequency is above Pentium 586.

○2 Memory space exceeds 64M.

○3 The available space of hard disk should be at least1000 mm.

○4 The display resolution is 1024*768 true color or higher.

○5 Two-button mouse, ordinary optical drive, sound card, etc.

2. Software environment

1 Operating System WINDOWS95/98/2000/XP/2003

2 SQL (Structured Query Language) Server 2000+Visual Basic

3.2 overview of visual basic

1. What is Visual Basic?

Visual Basic (VB for short) is a general object-based programming language developed by Microsoft.

"Visualization" refers to the method of developing a graphical user interface (GUI)-you don't need to write a lot of code to describe the appearance and location of interface elements, just add pre-established objects at a point on the screen.

"Basic" refers to Basic (beginner's general symbol instruction code) language, which is the most widely used language in the history of computing technology development. Visual BASIC is further developed on the basis of the original BASIC language. So far, it contains hundreds of statements, functions and keywords, many of which are directly related to Windows GUI. Professionals can use Visual Basic to realize the functions of any other Windows programming language, while beginners only need to master a few keywords to build practical applications. Visual Basic Scripting Edition (VBScript) is a widely used scripting language, which is a subset of Visual Basic language. It can be embedded in HTML language to design web pages, such as ASP(Active Server Page) files.

VB is easy to learn, universal and widely used.

2. The function of 2.VB

VB can be used to develop multimedia, database, network, graphics and other applications.

Data access allows the establishment of databases and front-end applications, as well as adjustable server-side components for most database formats, including Microsoft SQL Server and other enterprise databases.

With the help of ActiveX(TM) technology, you can use the functions provided by other applications, such as Microsoft Word word processor, Microsoft Excel spreadsheet and other Windows applications.

The complete application is true. Exe file, which can be distributed freely.

3.3 introduction to SQL

The full name of SQL is "Structured Query Language"

SQL (Structured Query Language) is a database query and programming language, which is used to access data, query, update and manage relational database systems.

SQL is also an extension of the database script file. SQL is an advanced non-procedural programming language, which allows users to work on advanced data structures. He doesn't need users to specify the storage mode of data, and he doesn't need users to know the specific storage mode of data, so different database systems with completely different underlying structures can use the same SQL language as the interface for data input and management. It takes the recordset as the operation object, and all SQL statements accept it as input and return it as output. This set feature allows the output of one SQL statement as the input of another, so SQL statements can be nested, which makes it very flexible and powerful. In most cases, in other languages, functions that need a long program can be realized by only one SQL statement, which means that very complicated statements can also be written in SQL language.

Fourth, the system function realization

The main functions of the system are: ○ 1 customer management, adding customers, customer checkout and exiting the system. 2 room management, you can know the room status and add new rooms. (3) Customer query, where you can query the basic information of customers, which can be divided into fine query and fuzzy query. (4) Administrators, administrators can add administrators and delete administrators.

Among them, the fine query is based on: (1) customer address (2) customer number (3) ID number (4) room number.

Fuzzy query press: (1) customer name (2) customer age.