Mahidol University Logo
Faculty of ICT, Mahidol University
 

Admissions

Printable Version

 

HOTEL FRONT OFFICE MANAGEMENT SYSTEM AND HOTEL DATA WAREHOUSE DEVELOPMENT

THAWEESAP  TATIYAPERMPOON        4988180   ITCS/B
KRITACHAI  PHONGCHAVALITHIRUN           4988254   ITCS/B
CHAYUTH  SUWANVONGKIJ                 4988298   ITCS/B

B.Sc. (INFORMATION AND COMMUNICATION TECHNOLOGY)
PROJECT ADVISOR: DR. SONGSRI TANGSRIPAIROJ

ABSTRACT

Nowadays, the hotel industry in Thailand is considered to be one of the most important economic business sectors. This research project aims to apply information and communication technology to a hotel business in order to help improve hotel front office management and to offer a smarter way to run the business. Lee Garden Resort, a famous modern family-style resort in North Pattaya, is the project case study. The problems of the current manual paper-based system that occur in the Lee Garden Resort were identified and the user requirements were studied.
In this research project, a hotel front office management system was designed and developed as a web application. The system facilitates several daily operations of the hotel front office management which include room reservation, room availability checking, check-in, check-out, service charging, billing and payment. All transactional data that occurs in the system is kept in an online transactional processing (OLTP) database. Moreover, a hotel data warehouse was constructed by gathering data from the OLTP database of the hotel front office management system. Online analytical processing (OLAP) data cubes and reports were provided for the managers to perform multi-dimensional data analysis in various statistical measurements such as the total number of customers who make an online reservation and check-into the hotel, total number of rooms occupied and vacant, length of stay and revenue of the hotel. This information is useful for the hotel managers in supporting their decision making and strategic planning in hotel management and administration.

KEYWORDS: HOTEL BUSINESS, DATA WAREHOUSE, OLTP, OLAP, WEB APPLICATION

Go to Top

 

ICT Building, Mahidol University, 999 Phuttamonthon 4 Road, Salaya, Nakhonpathom 73170 Tel. +66 02 441-0909 Fax. +66 02 849-6099
Mahidol University Computing Center, The Faculty of ICT, Mahidol University , Rama 6 Road, Rajathevi, Bangkok 10400 Tel. +66 02 354-4333 Fax. +66 02 354-7333