DESIGN AND IMPLEMENTATION OF A HOTEL MANAGEMENT INFORMATION SYSTEM
(A CASE STUDY OF ROYAL MARBLE HOTELS, BENIN)
ABSTRACT
This project research work is a construction of hotel management software (front desk operations) for Royal Marble Hotels in Benin, Edo State. Considering the problem of the manual method of reservation faced by the front desk clerk, it is hoped that automating front desk operations will help to reduce the cost of hotel services as market success largely depends on the price of a service. The first chapter is concerned with the background of the study, objective of the study, scope of the study definition of terms. The second chapter examines the literature review, under which the researcher examine some things such as: the meaning of hotel, what is management, what is software, the meaning of hotel management software, the benefits of computerizing a system, a brief history of Royal Marble Hotels Benin, Royal Marble Hotels organizational chart, job description and occupation of hotel staff, basic functions of the front desk clerk, computer in hotels e.t.c. The third chapter laid emphasis on the computer processes that can be associated with hotel entity, types of system, types of information systems, what is a database, types of database, system analysis and design e.t.c. The fourth chapter is on system implementation, testing, documentation and maintenance, source codes e.t.c while chapter five is on summary, conclusion and recommendation.
TABLE OF CONTENT
Content Page
Title Page ii
Approval Page iii
Dedication iv
Acknowledgement v
Abstract vi
Table of content vii
CHAPTER ONE
1.0 Background of the study 1
1.1 Objective of the study 2
1.2 Significance of the study 2
1.3 Scope of the study 4
1.4 Definition of terms 4
1.5 Limitation of the study
CHAPTER TWO
LITERATURE REVIEW
2.1 What is a hotel? 6
2.1 What is management? 7
2.2 What is software? 8
2.3 The meaning of hotel management software 10
2.4 Benefits of computerizing a system 12
2.5 the mission of royal marble hotels 16
2.6 job description and occupation of hotel staff
general manager 16
2.8 basic functions of the front desk clerk 18
2.8. Computers in hotels 19
CHAPTER THREE
3.1. What is a system? 20
3.2. Types of system 22
3.3. Types of information systems 23
3.4. What is a database? 25
3.5. Types of database 28
3.6. system analysis and design 29
3.7. analysis 30
3.8. system design 31
CHAPTER FOUR
4.0. system implementation, testing, documentation and maintenance 32
4.1. Implementation 32
4.2. Computer program testing 34
4.3. Documentation 35
4.4 maintenance 37
CHAPTER FIVE
5.0 Summary 38
5.1 Recommendation 38
5.2 Conclusion 39
References 41
Appendix A 42
Appendix B 43
Appendix C 44
CHAPTER ONE
INTRODUCTION
1.1. BACKGROUND OF THE STUDY
The hospitality industry, which is a major team player towards the economic growth of Nigeria as a nation and Africa as a continent has distinguished itself as a sector with the widest variety of hotel and tourism services.
There are many things in place in Nigeria now, which should encourage the growth of the hospitality business. These include:
1. The existence of opportunities by the democratic dispensation in the country, which influence the size and growth of both foreign and local business travelers.
2. Global expansion of international trade and also increase services of accommodation rendered by our local hotels.
3. Improvement of our tourist centers and zones.
4. Increase in Nigeria’s annual average growth rate of tourist arrivals.
5. Government favorable policy towards foreign investment.
An important feature of the hotel industry in Nigeria is that until the late seventies there was virtually absence of the well-known names in international hotel industry. From the late seventies however, some of these names began to make an appearance. Names like Sheraton Hotel, Hilton Hotel e.t.c.
Hotels are accessed for their standard of cleanliness and provision for visitors on a scale of one to five (1-5) stars. All aspect of hotel stay is accessed with emphasis on the standard of service, level of comfort and provision of equipment.
The assessment of accommodation gives you a clear indication of cleanliness, ambience, service, hospitality and accommodation standard of the hotel and the reassurance a guest needs to distinguish between the quality of the accommodation and the number of facilities on offer. Basically there are four types of hotels, namely:
1. COMMERCIAL HOTELS: It is also known as conference hotels, and is usually located in cities or suburban areas. They operate all year round.
2. RESORT HOTELS: Resort hotels are usually located primarily in vacation destinations near mountains and seashores. It offers luxurious surroundings with a variety of recreational facilities such as swimming pools, golf courses e.t.c. The business of resort hotels fluctuates with the season.
3. RESIDENTIAL HOTELS: Residential hotel combines the comfort of a permanent living with the convenience of a resort and a resident hotel.
4. CASINO HOTELS: Casino hotels provide lodging in hotel facilities with a casino in the premises. They also provide gambling facilities.
There are different occupations in a hotel; a list of these is discussed in chapter two. One of such occupation is the hotel front desk clerk, whose job is to:
i. Process reservation
ii. Handles guest registration, check in and check out
iii. Monitors arrivals and departures
iv. Handles complaints and
v. Receive and forward mails.
The duty of the hotel front desk clerk depends on the size of the hotel. In small hotels, the desk clerk may do everything, while in large hotels the duties are divided among several types of clerks.
Revenue is generated in a hotel through its point of sale. Hotel points of sale are locations where various services are offered. These points include the front desk, the bar, restaurant and the retail shop. At the end of each business day in a hotel, a manifest of guests is presented to the State Security Service (SSS) for security purposes.
1.2. OBJECTIVE OF STUDY
Considering the problem of the manual method of reservation faced by the front desk clerk, it is hoped that automating front desk operations will achieve the following:
1. Reduce the cost of hotel services as market success largely depends on the price of a service.
2. Take advantage facilities offered by the computers such as speed, accuracy and efficiency to carry out common task of check in, check out and guest registration. This cannot be compared to using a manual process.
3. Increase the volume of business. That is, more transaction can be made than humanly possible.
4. Supply better management information through reports, which will make information regarding the hotel, better organized and retrieved in the least possible time.
5. For long term forecast and planning.
6. Enables managers and front desk clerks to carry out operations that are otherwise impossible to carry out manually.
7. Security of data, as a result of the design of a database.
1.3. SCOPE OF STUDY
This work will attempt to automate front desk operations and these include:
i. Room reservation process
ii. Check in and check out operation
iii. Report generation from a database for managers as well as customers.
1.4. DEFINITION OF TERMS
Check in: To register as a guest in a hotel.
Check out: To pay one’s bill and leave a hotel.
Reservation: A record of rooms reserved for customers.
Front desk: Where guest makes reservation, check in and check out.
Front desk clerk: A person in charge of front desk operations and payment.
Ambience: The character and atmosphere of a hotel.
Database: A collection of data that are well organized.
Management: Act of running and controlling a business.
Software: The program(s) used to operate a computer.
Hotel points of sale: Locations where sale are made in a hotel.
Ingress: The act of entering the hotel.
Egress: The act leaving the hotel.
Lodging: A temporary accommodation in a room with meals.
Deposit: Money paid by guest during registration.
Credit Customers: Customers from companies or organizations that the management of the hotel has credit agreement with.
Outlet Cashier: The middleman between all points of sale and the accounts department.
ATM: Automatic teller machine.
1.5. LIMITATIONS OF STUDY
A major limitation to this work is non-availability of a documented report on the hotel operations in most hotels.
There was also time constraint and the proximity of the case study. Finance was also a limitation to this project work.