Hotel Room Management System Based On SQL Server2000

With China’s rapid economic development, people’s living standards have improvedsignificantly, the holiday economy and tourism economy has become a hot spot for humanconsumption. Also all over the local economic development of tourism as an importantpillar of the hotel so as to promote the rapid development of the hotel industry. Meanwhile,in today’s increasingly frequent exchanges of economic and business conditions, the hotelindustry is facing a surge in traffic pressure. More and more hotels, guest houses, thetraditional management approach has been recognized not suitable for the needs of today’ssociety, how to survive in the fierce competition in the development of hotels of every issuemust be faced.With the development of computer science and technology, database technologyapplication in all walks of life have been widely used to develop a database system toprovide people with convenient and efficient service has become a new trend. This article isbased on their study of vb and database knowledge for the development of hotel roommanagement system, the system can maximize the accurate, fast and efficient role in thehotel’s service management provide strong support. By using this system, the managementefficiency of Imperial Hotel has been dramatically improved.The overall objective is to build the project Dorsett hotel room informationmanagement platform, the use of computer room information management, to furtherimprove economic efficiency and modernization of the hotel. Hotel staff to help improvework efficiency, work flow to achieve room systematic information management,standardization and automation. Documents filled out by hand to avoid the past, lowefficiency, error-prone data, statistics, time-consuming phenomenon. The project will notonly meet current business needs, but also to meet future business development of the hotel,but also to have good scalability, portability, reusabilityThis article made the following key elements:(1) a simple introduction to the Visual Basic for Windows, database development and,SQL language foundation.(2) sets out the background of system development, system analysis and theachievement of goals.(3) design the system login module, registration module20, a few. (4) describes the system operating environment, installation settings, and use ofevaluation.(5) MD5encryption to ensure security of customer information.Hotel room management system to achieve room booking, accommodationregistration, lodging reminder, an additional deposit, transfer housing registration,check-out, unpaid debts, query statistics, the advance sales reports and more.Accommodation hostel fees which exceed the deposit can be reminded when the earlywarning, prompt prospects to customers pay a deposit, this feature can significantlyimprove the hostel fee for the effective management of staff accommodation. Registrationof dynamic real-time accommodation, room adjustments, sales reports, additional depositand other organically linked to the hotel room for a full range of management. The wholesystem is implemented on the interface design beautiful, various function keys at a glance,so that the operator more efficient and convenient to use.