DESIGN AND IMPLEMENTATION OF A HOTEL RESERVATION SYSTEM


Content

 

ABSTRACT

A hotel is an establishment that provides lodging paid on a short-term basis. The provision of basic accommodation, in times past, consisting only of a room with bed, a cupboard, a small table and a wash hand has largely been replaced by rooms with modern facilities, including en-suite bathrooms and air conditioning or climate control. Additional common features found in hotels rooms are telephone, television, a safe, a mini-bar with snack food and drinks

Hotel Reservation system is designed to be user friendly that provides flexible accommodation of wide range of requirements. The system is created to speed up transaction, and is designed for faster and easy booking online, lesser manpower, and less effort of the clients

The system is aimed to allow complete automation of the entire Fatel Hotel operations in the areas of booking, meals, accommodation, account details, inventory, reporting and so on. Moreover, special services such as laundry, ironing and room service will be automated by the system also, not to forget the additional facilities information that will be efficiently handled by the system. The system will have administrative login which is in two categories: the head administrator and the staff. Also the customers who make direct online booking from the website will be able to login into their account whenever a new booking is needed, so that they do not need to re-enter their information again. There will be auto-generation of invoice online for the customer that books online which will be a proof of service order in the hotel.

Data was gathered from reliable source that were all reference in this work and PHP components and JAVA SCRIPT, MYSQL SERVER database was used as the database.

This work is to improve the operational method of Fatel Hotel from the manual operation to automated processing system.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

TABLE OF CONTENTS

 

chapter One - Introduction

1.1       Overview  

1.2       Background     

1.3       Statement Of Problem  

1.4       Aims And Objectives:

1.4.1    Aims:

1.4.2    Objectives:

1.5       Scope Of Study 

1.6       Significance Of Study 

1.7       Limitations Of Study 

 

Chapter Two - Literature Review

2.1       Background Study 

2.1.1    Definition 

2.2       Comparism With Existing System  

2.3       Proposed System

 

Chapter Three –System Analysis And Design

3.1       Overview  

3.2       Waterfall Model

3.3       Phases In Waterfall Model

3.3.1    Planning         

3.3.2    System Analysis

3.3.3    System Design           

3.3.4    System Development 

3.4       System Requirement

3.4.1    Hardware Requirement

3.4.2    Software Requirement

3.4.3    Requirement Justification 

3.5       Data Analysis 

3.5.1    Observation 

3.5.2    Interview  

3.5.3    Data Research Conclusion     

3.5.4    Justification Of The Techniques 

3.6       System Design 

3.6.1    Introduction 

3.6.2    Use Case Diagram For Fatel Hotel

3.6.3    Activity Diagram For Fatel Hotel

3.7       Class Diagram For Fatel Hotel

3.7.1    Multiplication Assumption Of The Class Diagram  

3.7.2    Entity Relationship Diagram  

 

CHAPTER FOUR: SYSTEM DEVELOPMENT & IMPLEMENTATION

4.1       Introduction 

4.1.1    Implementation 

4.1.2    System Implementation Requirement

4. 2      Proposed System Screen Shots 

4.2.1    Client Operations 

4.2.2    Client Home Page 

4.2.3.   About Us Page 

4.2.4.   Service Page 

4.2.5.   Contact Us 

4.2.6.   Reservation 

4.2.7.   Search List

4.2.8.   Room Details Page 

4.2.9.   Client Personal And Billing Details

4.2.10. Printable Receipt Page 

4.2.11. Print Preview Page 

4.2.12. Client Profile 

4.2.13. Booking History 

4.2.14. Booking Cancellation 

4.2.15. Staff Operations 

4.3       Staff Operations 

4.3.1    Administrator / Staff Login

4.3.2    Admin Home Page 

4.3.3    Adding New Room Class 

4.3.4    Managing Room Details 

4.3.5    Manage Client Details

4.3.6    Booking History 

4.3.7    Billing History 

4.3.8    Manage Users 

4.4       Testing 

4.4.1    Unit Testing 

4.4.2    Integration Testing 

4.4.3    Sample Test Cases 

 

CHAPTER FIVE – EVALUATION ANALYSIS & CONCLUSION

5.1       Introduction 

5.1.1    Sample Evaluation Questionnaire 

5.1.2    Data Analysis Conclusion 

5.2       Software Evaluation 

5.3       Future Enhancement   

5.4       Final Conclusion 

REFERENCES

APPENDIX – SCHEDULE

CHAPTER ONE

INTRODUCTION

 

1.1              OVERVIEW

Fatel Hotel Provides solution regarding the hotel reservation problems of users,this chapter will briefly explain the synopsis of the system with a background of the system, aim of the system, objective of the system, the system problem statement and scope.

 

1.2     BACKGROUND

A hotel is an establishment that provides lodging paid on a short-term basis. The provision of basic accommodation, in times past, consisting only of a room with bed, a cupboard, a small table and a wash hand has largely been replaced by rooms with modern facilities, including en-suite bathrooms and air conditioning or climate control. Additional common features found in hotels rooms are telephone, television, a safe, a mini-bar with snack food and drinks.

Hotels serves many purposes such as a resting place for travelers and tourists and its facilities offers guest hospitability in various ways. Modern hotels are equipped with Swimming pool, Fitness center, Business center, Childcare, Transportation means, Entertainment, Conference facilities and Social function services.

Technology offers new renovation and revolution to meet customers ‘wishes. This renovation and transformation brought about the online reservation system to help their customers to make reservation easy and reduce the work of the staff.

The reservation systems became more efficient and offered the hotelier a new dimension in the creation of customer loyalty, the database. The records of each guest’s individual history have helped create individualized marketing programs and have enabled hotels to satisfy a guest’s personal need from the moment of his/her arrival.

The hotel online Management system was launched to make front desk more efficient and accessible to the guest, its launch lead to communication of the hotels facilities and hospitability’s through the website to provide a comprehensive view of hotel and helps to make booking of hotel easy. It is no wonder that booking hotel rooms can now be done in a more convenient way today. If a certain traveler is planning to visit a foreign place, it would be hard for them if he/she does not have a hotel or residence to reside in that country. Before, booking a certain hotel room required long processes such as talking to an hotelier either in person or through the phone. Just imagine the disposition of the hotelier if multiple clients came to ask questions about reservations at the same time. Through an online hotel reservation system, hoteliers and travelers will both be benefited. Hotels have minimal need of travel agents to look for clients because information about their business establishment is readily available online. Hotel Reservation system is designed to be user friendly that provides flexible accommodation of wide range of requirements. Hotel Reservation system is created to speed up transaction, and is designed for faster and easy booking online, lesser manpower, and less effort of the clients.

Technology is making waves in hospitality industry and hotels across the globe. The quest for better performance, smooth operation and efficiency in the hospitality industry has given to the acquisition of host of hotel management system today. Fatel is a hotel with completely manual operations, all the daily activities of the hotel are performed manually which has led to many problems such as human error, inefficient recording system, inappropriate invoicing control, lack of good communication, and many others. The proposed Fatel Hotel Reservation System will be able to handle all the flaws and limitations of the former manual operations.

 

1.3     STATEMENT OF PROBLEM

Difficult to Locate Customer Files:Due to the numerous customers, location of customer files during checking in, checking out, updating of daily expenditures and receipt generation is extremely difficult for the hotel staff.

Enormous Storage Space Used Up:Due to the manual file keeping,the physical files occupy enormous space of about two rooms full of file cabinets, which thereby occupies the hotel’s space that could have otherwise been used to generate more income.

Human Computational Errors:Duetomany errors generated during data computation, the hotel accrued heavy loss on daily basis.

Difficulty in Reporting and Data Analysis:The data analysis and reporting generation has not been easy for the hotel, especially the managers.

Poor Data Storage and Paper Wastage: All the data is stored in filing cabinets. Data could be misplaced due to human error or in the event of a break data could be stolen very easily. Much paper is waste due to the number of customers in the company. Information on each reservation is stored in the customer’s file on another page.

Lack of Secured Record: There is lack of security in the manual system as there is no limitation on who can access the records. Any staff can change the records and this may cause serious problem in the future. For instance, intruders can effortlessly steal the critical information about their extraordinary client details or even a staff that might not have the power in the hotel information might take the information content and sell it to other person.

1.4     AIMS AND OBJECTIVES

1.4.1  AIMS

 The major aim of this study is to improve the operational method of Fatel Hotel from the manual operation to automated processing system. This system will effectively and efficiently keep all necessary information about the hotel to help the customer have accessibility to the information of the hotel.

 

1.4.2 OBJECTIVES:

Ø To design a system to exchange from manual system to online based system.

Ø To provide a search facility for customers.

Ø To create contingency plan for database recovery in case of natural disasters.

Ø To automate the reservation and availability of hotel.

Ø Reservation process.

Ø To provide the customer a directive using Google map functionality.

Ø To ensure efficient and reliable communication within the hotel.

Ø To improve management decision making

Ø To generate timely and sophisticated report

To provide customer with information about the hotel and facilities, the system will allow complete automation of the entire Fatel hotel operations in the areas of booking, meals, accommodation, account details, inventory, reporting and so on. Moreover, special services such as laundry, ironing and room service will be automated by the system also, not to forget the additional facilities information that will be efficiently handled by the system.

The system will have administrative login which is in two categories: the head administrator and the staff. Also the customers who make direct online booking from the website will be able to login into their account whenever a new booking is needed, so that they do not need to re-enter their information again. There will be auto- generation of invoice online for the customer that books online which will be a proof of service order in the hotel.

 

1.5     SCOPE OF STUDY      

This study covers vital information about the Hotel to provide customer with information about the hotel and facilities for the system will allow complete automation of the entire Fatel hotel operations in the areas of booking, meals, accommodation, account details, inventory, reporting and so on and to help the staff with updating of daily expenditures and receipt generation.

 

1.6     SIGNIFICANCE OF STUDY

The significance and relevant of this study cut across the day to day service of the hotel. It also make the job of staffs and personnel a lot easier especially those involved in record keeping and searching of customer information and account details of their booking all of which was done manually. This study provides for them a user friendly environment to carry out their duties effectively and making customer booking easier by using the online reservation system available on the web page. The customers and staff have their information available at their fingertips and the management also get an update of the running of the hotel.

 

1.7     LIMITATIONS OF STUDY

Ø Study does not include any record or information about the customer except for their Login Details.

Ø There is no perfect system anywhere; every system needs improvement.

 

 

 

 

 

Order Complete Project