hotel management system

design outline

Introduction 2

I. System design process 3

1.1 System design steps 3

1.2 Division of functional modules 3

II. System characteristics 4

III. System operating environment 4

3.1 System operating environment 4

3.2 VB. 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 11

4.3.2 check-out settlement 12 < Summary 13

Reference 13

Attachment: Program List 14

Development of Hotel Management System

Abstract: A modern hotel is a consumer place integrating guest rooms, restaurants, communications, entertainment, business culture and other services and facilities. The hotel has a huge organization, many services and a large amount of information. In order to improve labor production, reduce costs and improve service quality and management level, This design is based on the characteristics of hotels, small and medium-sized hotels and hotels, and develops a software system suitable for hotel, small and medium-sized hotels and hotels.

Keywords: hotel management system development

Introduction: 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 Chinese people have improved significantly, and the demand for catering industry in the whole society has also increased. With the sustained 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 the hotel's daily business plays a decisive role in the hotel's operation.

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 a good practical application. People have always used 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 a lot of difficulties to find, update and maintain, and at the same time, it also increases the workload and work difficulty of managers. This system overcomes these shortcomings well, and has the advantages of quick 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, and are also important conditions for scientific and standardized hotel management and integration with the world. With Microsoft SQL Server 2111 as the background database and Visual Basic 6.1 as the foreground development tool, the system has completed the main modules of the hotel management system by using the modular structure design idea of top-down layer-by-layer decomposition and object-oriented design method. Nowadays, with the continuous development of economy, the business volume of hotel market brought by traveling abroad has greatly increased. In this way, there is a series of data import and export such as room management and check-in. Most dealers only use simple Office Excel to record, which is inconvenient in query and record. If we design a special software for hotel managers and hotel employees to inquire about the hotel information, as well as all kinds of reservation, check-in, check-out, settlement and check-out, it will greatly reduce the work of sellers and increase the 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 the hotel management.

1. System design process

1.1 System design steps

According to the relevant rules and regulations and management processes of our school, our team first established a management model by using rapid prototyping programming coding method. After full communication with the school instructors, the model was optimized, the design was improved, and the original workflow was transformed. Due to the adoption of Microsoft Visual Basic 6.1 programming, modeling and code writing were almost synchronized, which greatly improved.

1.2 Division of functional modules

1. Customer management

Customer management is the centralized recording and modification of customer information by administrators, which improves the efficiency of handling customer information 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 query

Customer query means that the administrator searches the customer information, and the search points are very detailed, including fine query and fuzzy query. In the fine query, the customer address, customer number, ID number, room number and so on are also divided.

4. Administrators

Administrators manage the information of the system. Administrators can modify, add and delete the information of the system. There are multiple administrators, but administrators who enter the system can delete and add administrators in the system.

2. Characteristics of the system

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

2. The software is easy to learn and use, simple to operate and widely applicable.

3. This system has a powerful query function.

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

iii. System operating environment

3.1 System operating environment

1. Hardware environment

○ 1. CPU frequency is above Pentium586

○2. Memory space is above 64M

○3. Hard disk free space is at least 111M

○4. Monitor resolution is 124 * 768. True color or higher

. Software environment

○1 Operating system Windows 95/98/2111/XP/2113

○ 2 SQL (Structured Query Language) Server 2111+Visual Basic

3.2 Overview of Visual Basic

1. What is Visual Basic

Visual Basic (VB for short) is a general purpose developed by Microsoft.

"Visual" 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, but you just need to add pre-established objects to a point on the screen.

"Basic" refers to Basic (Beginners All-Purpose Symbolic Instruction Code), which is the most widely used language in the development history of computing technology. Visual BASIC is further developed on the basis of the original Basic language. Up to now, 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 can build practical applications only by mastering a few keywords. Visual Basic Scripting Edition (VBScript) is a widely used scripting language, which is a subset of Visual Basic language and can be embedded in HTML language for web page design, such as ASP(Active Server Page) files.

VB is easy to learn, universal and widely used.

2. Functions of VB

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

the data access feature 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 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 completed application is a real. exe file using the Visual Basic virtual machine, which can be freely distributed.

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 and query, update and manage relational database systems.

SQL is also the extension of the database script file. SQL is an advanced non-procedural programming language, which allows users to work on high-level data structures. He does not require users to specify the storage method of data, nor does he need users to know the specific storage method 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 set of records as the operation object, and all SQL statements accept the set as the input and return the set as the output. This set feature allows the output of one SQL statement to be the input of another SQL statement, so SQL statements can be nested, which makes it extremely flexible and powerful. In most cases, in other languages, functions that require a large section of programs can be achieved with only one SQL statement, which also means that very complicated statements can be written in SQL language.

iv. realization of system functions

the main functions of the system are: ○1 customer management, where new customers are added, customers check out and settle accounts, and exit the system. 2 room management, where you can know the room status and add new rooms. (3) customer query, here you can query the basic information of customers, which can be divided into fine query and fuzzy query. (4) the administrator, the administrator can add administrators and delete administrators.

fine query press: (1) customer address (2) customer number (3) ID number (4) room number

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