Final Draft Hotel PDF
Final Draft Hotel PDF
Final Draft Hotel PDF
CHAPTER 1
BACKGROUND OF THE STUDY
1.0 Introduction
Hotel Reservation and Centralized Billing System is a transaction processing system that solves
the problem encountered in using the manual hotel reservation. The Hotel Reservation and
Centralized Billing System aims to simplify the manual hotel reservation faster and more accurate.
Database is shared thru Wide Area Network (WAN). The researchers make use of some tools and
techniques to build the project. The system uses Graphical User Interface (GUI) to help the user
easily manage the system. The system, once implemented, will solve the most common problems
that the hotel reservation encounters.
Today, most of the hotels provide goods and services using computer system. It help them to
perform task in an easy way with less time consumed. Some companies become fully automated while
others strive for the similar setting.
The advent of new technology gave rise to easy and hassle free interaction between and among
humans whether it is in business, science or whatever task, a person takes on the quality and speed of
carrying out an enhanced technology through automation or computer enabled services with efficiency
and quality as its bedrock.
Today, more and more systems are moving towards IT enabled process to facilitate day to day
transaction. The hotel reservation system is a transaction processing system that is more advantageous
over the traditional manual process.
Page | 1
.
1.2 Purpose and Description
The purpose of the system is to develop a web-based hotel reservation with
centralized billing system.
The projects goal is to give a more convenient way of reserving a hotel room.
HRCBS is used in the title as it is an abbreviation which means Hotel Reservation
with Centralized Billing System.
Page | 2
General Objective
The main objective of this research project is to design, develop, test and
evaluate a Hotel Reservation and Centralized Billing System that helps customers
to check and book available hotel rooms and have it paid once the guest/guests
reach the hotel.
1.3.2
Specific Objectives
The following are the specific objectives the researchers plan to accomplish:
a) Creates a module that displays the available hotel rooms in a specific date
entered by the guest(s) to book;
b) Creates information management module that summarizes information
about the different hotel rooms available for booking and other facilities
that can give the guest the edge of maximizing his interest about the hotel.
c) Creates account management module that enables admin to change the
availability of a room booked by the guest(s).
Page | 3
d) Creates centralized billing module that enables the system to computes all
of the purchases made by the guest(s) in the hotel; and
e) Generate guest bills thru automatic computations of all the acquired
services of the guest during his stay.
1.4 Scope and Limitations
This study is conducted to determine on how researchers will help the hotel management
process.
A Hotel Reservation and Centralized Billing System is fully scalable and designed to
provide extensive flexibility and varied choices. Typical hotel reservation and e-commerce hotel
system software reservation solutions currently in place and available today are technically
designed to achieve only one objective function, which is to connect buyer to seller.
1.4.1
Scope
This study mainly focused on providing an effective transaction
processing system especially in the Hotel industry that enables businesses to track
services and aims to provide accurate and reliable process on every transaction
especially in a hotel reservation. This study looked into a better impact of using
technology today on how it affects our daily lives especially for being the
customer. With this study it can help the beneficiaries to know the differences
between using manual system.
Page | 4
1.4.2
Limitations
The Hotel Reservation and Centralized Billing System is designed to
manage hotel bookings a standard procedure made directly by guests. Its powerful
hotel reservation, marketing & merchandising features gives you the ability to
control dynamic room or tour allotments, distribute confidential trade rates,
provide varying rates and commissions, multiple seasons, distributing last minute
rates. The Hotel Reservation and Centralized Billing System will allow you to
control your hotel reservation.
1.5 Significance of the Project or Project Justification
By developing a service for hotel reservation system, it can help customers to
book a hotel room without doing manual reservation. It can simplify the work and not
wasting much time. Moreover, it is an easier solution rather than to fill up a form
manually.
Hotels who use this service will have to type in the name of the customer, check
in date, and number of rooms required on their computer and inputs the information to a
database. Customers will, then, be informed whether the reservations have been
approved.
Company The proposed system will make the procedure faster and easier and
will lessen time waiting for the guest/guests to pay for their order
Manager This system lessens the work to be done by the manager because it can
generate reports easily.
Page | 5
Employees This system helps them to give accurate information and billing
statement to the customer.
Guest/Guests They will have no difficulty in paying bills when the hotel
delivers their order. The proposed system gives accurate information and expenses they
made when the guest/guests checks out the hotel.
1.6 Conceptual Definition
A hotel reservation system. It is a computerized system that stores and
distributes information of a hotel, resort, or other lodging facilities.
Mobile Operating System. It is a set of data and programs that runs on a
computer or mobile device. It manages all the hardware and optimizes the
efficacy of the application software in the device.
Module. It is a self-contained component of a system, often
interchangeable, which has a well-defined interface to the other components.
Centralized Billing System. It is a combination of software and hardware
that receives detail and service usage information, groups this information for
specific accounts or customers, produces invoices, creates reports for
management, and records (posts) payments made to customer accounts.
Page | 6
CHAPTER 2
REVIEW OF RELATED LITERATURE AND STUDIES
This section covers the related studies as well as the foreign and local parallel studies of
the proposed system gathered from several studies such as Internet, documentary works of other
graduates and professionals in order to enhance the studies of the proposed system.
The purpose of this study is to help the hotels in their business transactions, and make
their work much faster, easier and more accurate
PHP stands for Pre-Hyper processor which is a server side scripting language that
is used for forwarding data from websites to the server or retrieve data from a database
linked to the website. In the system, PHP was used to apply data from the forms on the
website and then compare it with the researchers used it to retrieve the data from the
forms on the website and then compare it with the database or create a new database
entry.
HTML (Hypertext Markup Language)
HTML stands for Hypertext Markup Language and is another scripting language.
This scripting language is only used for designing and developing a website. The
researchers used HTML to create the skeleton or structure of the system in terms of
design and layout.
CSS (Cascading Style Sheets)
CSS stands for Cascading Style Sheets and is primarily used with HTML. CSS is
commonly used to apply several styles by just linking one file. This way designs can be
easily applied to the website. This was also the case with the proposed system and the
researchers used it for applying the designs onto the structures of the system making it
more appealing to the user.
XAMMP (Cross Platform, Apache, MYSQL, PHP and PERL)
The XAMPP application is used for development and testing. It serves as the
database (MYSQL) and web (APACHE) serve while the system is being developed. It
also contains Pre-Hyper processor (PHP) which is the language that the researchers use.
Page | 8
Android
It is a mobile operating system (OS) based on the Linux kernel and currently
developed by Google.
Page | 9
hotel reviews are 100 percent authentic, submitted by customers after they
have completed their hotel stay.
The proponents system will also send confirmation letter to
customers who have requested for reservation to ensure them that their
reservation is valid and can be rest assured that when they come to the
hotel, they have a room waiting for them.
2.2.3. HRS.com
HRS operates a global electronic hotel reservation system for
business and private travelers based on a database of more than 250,000
hotels in all price categories in Germany, Europe and the rest of the world.
This system enables users to make direct reservations free of charge, with
immediate confirmation and at continually-updated special HRS prices.
The room prices quoted for selected hotels are guaranteed for the
reservation in question.
HRS.com is similar to the proponents system that also have
database that contains all the necessary information about the hotel. The
database of the system will give the company the security that whatever
may happen to the hardcopy of all their transactions, they have a back-up
stored in the systems database.
2.2.4. ebookers.com
The system uses innovative technology to enable leisure and
business travelers to research, plan and book a broad range of travel
Page | 10
products. Ebookers also offer holiday package can offer unrivalled value
and quality, whether you're looking for a European city break, a sunshine
getaway in the tropics or a sporting holiday on the Algarve.
The system of the proponents considers the long-stay promo of
Hotel De Gloria Inc., Cavite making automated computation of bills that is
fitting to the promo offered. There are also times where the company
increases their rate, especially during peak season, which the proponents
will include in the system.
2.2.5. Best Reliable Online Hotel Booking Company Reviews by Edwin M.
Clark
When it comes to choosing which companies to use to book hotels
online you should find a company that specializes in the hotel market for
the country you are planning to visit. It is really that simple. Normally we
would book our hotels using the services of the biggest and most well
known Internet travel agencies such as Travelocity or Priceline.
The main reason why local based hotel reservation agencies are
able to get the best deals is because they have a much better understanding
about the region they represent and have a closer partnership with the
hotels they are partnered with. Hotels realize that these agencies have a
greater potential of getting their properties known.
Even though you may not have heard of any of these companies
before they are certainly well known throughout the regions they are based
in. Booking a hotel online is simple and easy these days. Remember to
Page | 11
think local and book local. Its one of the best ways of landing yourself the
best hotel deals.
2.2.6. Hotel Swiss-Garden Kuala Lumpur(2008)
The
official
website
for
Hotel
Swiss-Garden
is
tour. Anyway, each visitor will have to install Java application before they
can view the virtual tour application.
As conclusion, Shangri-La Sentosa online reservation system is an
efficient, powerful and robust online system. The good characteristics of
this online system should be learn and apply in the developed system. In
order to enhance the current system, the system is developed to enables
every visitors having their virtual tour on hotel. The developed system is
appeared to be more attractive, efficient and dynamic to attract more
customers.
2.2.8. Marco Polo Guesthouse.
The official website is http://www.penangguesthouse.com.. The
core functions of Marco Polo Guesthouse online reservation system are to
provide online room reservation, hotel information and
tourist
persons number and email clearly. In case visitors have any questioners,
they can call or write to the contact person. Suggestions from guest are
good to help the hotel business growing.
Anyway, the online system did not provide an instant booking
system. Guests will have to wait for confirmation within 24 hours after
their booking. To enhance the current system, system is developed to
enables guest have availability checks and instant confirmation of the
booking. The purpose of this feature is to save valuable time and to cut
cost, as it will eliminate email exchanges between guests and reservation
department. Valuable reservations staff time is saved because reservation
requests will no longer have to be processed. Although the online system
had included the picture for the bedroom, kitchen and dining room,
visitors only can view of it. With a more advance feature provide in
developed system, visitors will be able to view the whole room, for every
angle of the room. The current online system for Marco Polo Guesthouse
did not include the management for housekeeping. In addition to enhance
the functionality of developed system, a Housekeeping features added
for housekeeper to perform their daily work.
2.3.Related Literature
2.3.1. Online Billing and Reservation System for Royal Palm Paradise
Resort (C.L. Adap, J.R. San Juan, P.B. Sillo, March 2013)
Page | 16
The system contains two pages which are Administrator page and
Customer page. The Administrator page has the authority to access the
whole system and will be able to update all the records of the customers
for reservations made through phone call or walk-in customers, change the
status of the reservation of the customers, update the list of the facilities
available in the resort. Computation of bills of reservation and add-ons,
and generating of reports are also under the Administrator page.
The proponents system also contains an administrator page that
can view all the transactions made within the system, including the people
who made reservations, their reservations and their total bills. The
proposed system will also enable the administrator to generate reports
about the information about the reservations made and the total income
they earned.
Page | 17
2.3.2. Online Billing and Reservation System of Adams Beach Resort (J.A.
Legaspi, M. Lamson, P.V. Gazme, March 2011)
The Online Billing and Reservation System of Adams Beach
Resort was developed in order for the company to have a systematized
form of operation and transaction in addition to a trouble-free work for the
officers-in-charge. The system has a user-friendly environment and
includes reservation packages, services and procedures.
The proponents system is like the Online Billing and Reservation
System of Adams Beach Resort because it is also developed to provide a
systematic operation and transaction for Hotel De Gloria Inc., Cavite to
help both the company and the customers by giving a convenient way of
billing and reservation process.
Page | 18
also use credit cards as the mode of payment and the hotel also requires
50% downpayment for any reservation
2.3.5. OBrien and Marakas, 2010.
Information systems are necessary for a business survival and an
effective computerized information system has been known as a vital
business advantage. State that information systems can be any organized
combination of people, hardware, software, communications networks,
data resources and
Page | 19
WIFI in Lobby, Restaurant Only. Php 100/hour for in-room internet use.
Free buffet breakfast in all rooms. Hotel does not offer room only rate.
Microtel by Wyndham stands out from other properties because
of the system-wide design of its buildings and furnishings that stress
function, comfort, and convenience, while at the same time meeting
international quality standards.
The online system did not provide an instant booking system.
Guests will have to wait for confirmation within 24 hours after their
booking. To enhance the current system, system is developed to enables
guest have availability checks and instant confirmation of the booking.
The purpose of this feature is to save valuable time and to cut cost, as it
will eliminate email exchanges between guests and reservation
department. Valuable reservations staff time is saved because reservation
requests will no longer have to be processed.
As conclusion, system will be developed to have an instant
booking for the room and meals. There is a back office for them to
control the content of the portal. This is to help hotel in better management
of their reservation and
2.3.9. Shangri-La's Mactan Resort & Spa (20l3)
A resort hotel owned by Shangri-La Hotels and Resorts located at
the island of Mactan, Cebu. It was once the Philippines' largest resorts,
Page | 21
equipped with 547 guest rooms and suites.Shangri-La's Mactan Resort and
Spa, Cebu received the ASEAN Green Hotel Standard at the ASEAN
Tourism Forum 2008 held recently in Bangkok, Thailand.Since it opened
in October 1993, Shangri-Las Mactan Resort and Spa, Cebu has won
various awards from international institutions such as Asia Money,
Business Traveller, Conde Nast, HotelClub.com, Smart Travel Asia, Time
Magazine, Travel Weekly (for Best Spa) and Zagat Worlds Top Hotels,
Resorts and Spas.
Besides, the website also includes a fantastic function, which is
virtual tour for hotel. The places available in virtual tour are lobby, rooms,
function rooms, recreation, restaurant and bars. Visitors can use their
computer mouse to navigate around the hotel. For business person usage,
the website provides a form for quest to fill in their reservation details. In
addition to room reservation, guests may fill in another form to make
special request for their reservation. The structure of this website is well
organized and easy to navigate through. Visitors may get a lot of
information from this website
As conclusion, Shangri-Las Mactan Resort &SPA online
reservation system is an efficient, powerful and robust online system. The
good characteristics of this online system should be learn and apply in the
developed system. In order to enhance the current system, the system is
developed to enables every visitors having their virtual tour on hotel. The
Page | 22
had included the picture for the bedroom, kitchen and dining room,
visitors only can view of it. With a more advance feature provide in
developed system, visitors will be able to view the whole room, for every
angle of the room. The current online system for Marco Polo Hotel did not
include the management for housekeeping. In addition to enhance the
functionality of developed system, a Housekeeping features added for
housekeeper to perform their daily work.
As conclusion of this case study, system will be developed to have
an instant booking for the room and meals. There is a back office for
them to control the content of the portal. This is to help hotel in better
management
of
their
reservation
and
content
of
portal.
The
discounts, having beautiful and relaxing environment and above all having
a
state
of
the
art
computer
system
and
facilities.
The current problem observed is the manual guest list records, the
manual reservation of guests, the manual booking of rooms for the guests
which
takes
long
time
to
accomplish.
Page | 25
Page | 26
Page | 27
CHAPTER 3
METHODOLOGY AND DESIGN
3.1 Organizational Assessment
In the year 2003, the institution gave high priority to the need to offer hospitality
courses. In the same year, Systems Plus College Foundation answered this necessity by
establishing a College that catered various discipline in the field of hospitality. Thus, this
realization paved the way to the inception of the College of Hospitality Management.
The first two programs, Bachelor of Science in Hotel and Restaurant Management
(BSHRM) and Bachelor of Science in Tourism (BST), Opening its doors to these
pioneering students marked its first year as a novel College of the institution.
Since then, SPCF and the College of Hospitality Management (CHM) braved itself
to be one of the Higher Learning Institutions (HEI) in Pampanga that produces highly
qualified graduates in the field of hospitality management.
The study focuses on managing the hotel reservation process that will allow the user
to check available rooms in the hotel, manage reservations and book a hotel room online.
The Centralized Billing Module, a system that computes all of the purchases made by the
guest/guests in the hotel. Because it is developed for the hotel reservation, they can
control all of the expenses made by the customer within the hotel, summarizes the bills
and extra charges of the guest and also they can view the status of every hotel rooms.
Page | 28
3.1.1
Operational Feasibility
The researchers have observed problems in the processes of
making a hotel room reservation. The problem that the staff and
customers encountered was the unmanaged customer database,
manual registration when making a reservation and it will be a
waste of time for the customers going to the hotel and knowing
that there are no available room to reserve. That is why the
researchers have come up with a module for the study which
allows:
3.1.2
Technical Feasibility
The proposed system is a web and mobile based system
which gives the user ease of use. The only main requirement in
order to run the system is to have a stable and adequate Internet
connection, a smartphone and a computer system. So when tested
and implemented at the locale, the only things needed are a
Page | 29
Schedule Feasibility
In tackling the development of the system, the researchers
decided to allot a certain amount of time to different tasks that
need to be undergone in order for the successful development of
the system. The allocated one (1) month for extensive data
gathering in order to properly grasp the essence of the hotel
reservation process. During the data gathering, prototypes of the
system were conceptualized.
3.1.4
Economic Feasibility
Making a reservation in a hotel would be a lot easier due to
the system. For example instead of going directly to the hotel the
customer can check the website with their phone or in a computer
to see if there are rooms available and what services do they offer.
On the other hand the benefits of the research to the admin and the
staff would be mainly non tangible. The benefits includes the
increase in processes of making a hotel reservation, increase in
online advertisement, generating the remaining and additional
balance of the customer and checking of the status of every room
could be easier and faster to process. Through the system the
admin and the staff would be working more efficiently.
Page | 30
BENEFIT
Development cost.
Hosting of system.
additional balance
Requirements Analysis
HRCBS is a system that features the essence of a hotel reservation and
centralized billing system. It has the capabilities to manage the hotel
reservation and other services of the hotel. Making a reservation will be
managed through the use of HRCBS. Managing hotel rooms and staffs
will be made easier through the use of the system. The system will be able
to help the user in booking a hotel room easier and less time consuming.
Page | 31
3.2.2
Functional Requirements
Page | 32
3.2.3
When logging in, the user needs to provide his username and password. This will redirect the
user to the respective home screen of the user. On the other hand when registering for the
system the user will need to input his first name, last name, e-mail address, password and
chose a host to which the user wants to belong to. Upon registering the user will be redirected
to the Group Selection Interface.
Page | 34
As shown in figure 2, the initial page that the user can access upon finishing
registration, is limited in functionality due to the pending status of the user. After being
approved by the admin the whole features will be available which are designated for the user
types which includes staff and customer once being appointed by the admin.
Page | 35
As shown in Figure 3 the admin panel where the hotel admin can edit the content
of the website.
Page | 36
In figure 4 the Cashier panel where all of the purchases made by the customer within
the hotel are being recorded and manage the price of every items.
Page | 37
As shown in figure 5, 6, 7 the Customers Homepage shows what the users see in the
website such as the homepage, about us and booking.
Figure 5. Homepage
Figure 6. About Us
Page | 38
Figure 7. Booking
Page | 39
The researchers have used context diagram as a guide to analyze the process
that happens inside the system. The system shows the interactions including the input
and output of each module. The Context Diagram can be found in Appendix D.
The system flowchart stars with the access of the system. From there on the
system would ask for the login of the user. The user will then be redirected to the
interface of the main menu of the system. From this point on he will only be able to
access the systems function. The user can then start making a hotel reservation. The
system flow chart can be found on Appendix F.
Page | 40
The use case diagram depicts the accessibility of functions to the different
users. It shows that the admin has access to the user management, product or service
management and posting gallery. In the staff has the access to the profile, product,
room and billing management. The Use Case Diagram can be found in Appendix G.
While on the process of developing the study, the following are the application
softwares used:
Windows 7 Ultimate
Google Chrome
Mozilla Firefox
Adobe Photoshop
Adobe Illustrator
Notepad++
Adobe Dreamweaver
Page | 41
3.5.2
The following are the hardware used during the development of the
study.
Motherboard
Processor
PSU
Optical Drive
HP DVD1260 DVD+RW
Android Device
Dongle
N/A / PLDT
Page | 42
Page | 43
4. The Test Plan with the test tool questions was validated by an IT expert to ensure that the
items to be tested are appropriate for the Paper Conference Management System website.
5. The bugs that were discovered in the test tool were addressed by the developer if deemed
necessary and/or within the requirement specifications of the website.
3.7 Evaluation Procedure
A survey was conducted to evaluate the performance of the system. Respondents were
the selected forty (40) students undergoing the capstone subject and five(5) knowledgeable IT
specialists/industry practitioners or teachers at the locale holding a Masters degree. The
following activities were undertaken in the evaluation process:
1. The researchers discussed the concept of the system and its operation for the
respondents familiarization;
2. The researchers presented the system through demonstration to show how it worked;
3. Question and answer followed after the demonstration for some clarifications;
Page | 44
4. The evaluation questionnaire (Appendix I) was given to the respondents for them to
answer. They were requested to rate the system based on different criterion specified
in the instrument using the Likert Scale in Table 4.
5. The instruments were collected, data were tallied and summarized, and the mean was
computed;
6. The overall rating was interpreted using numerical rating and equivalent in Table 3
Numerical Rating
Interpretation
4.51 - 5.00
Excellent
4
3
2
1
4.50
3.50
2.50
1.50
Very Good
Good
Fair
Poor
Page | 45
CHAPTER 4
RESULTS AND DISCUSSION
This chapter presents the results and discussion of the project study. It includes the
project description, project structure, project capabilities and limitations and project testing and
evaluation.
4.1 Project Description
This study focused on the development of a web-based Online Hotel Reservation
and Centralized Billing System that will manage the hotel reservation of the CHM department of
Systems Plus College Foundation. This study will help the dynamic versatile features required
to run your hotel, and guest house business. Online Hotel Reservation and Centralized Billing
System offers an operational integration between reservations, guest history, reception/ front
desk, Sales Ledger, and Reporting modules. Software has facility to generate report for analyzes
your booking, check in and checkout status. Online Hotel Reservation and Centralized Billing
System is the best suit for managing you resource in very simple but effective manner with
minimal efforts or time so that it increases your revenue. This study aims to change the current
system that would be accurate for both customer and hotel management. The proponents use
diagrams to implement the flow of the proposed system.
4.2 Project Structure
The project structure is best described using the functionalities provided by the system to various
access controls. Access Controls are the roles played by the various stakeholders who would be
using the web-based project of this study.
Page | 46
Account Type
Website Admin
Front Desk
Customer
Housekeeper
Capabilities
Verifies account
Register details
Manage user/customer accounts.
Create/Edit news, and new announcements.
View the website
Manage the content (Add, edit and delete)
Manage profile
View the website
Manage room information
Manage customers requests.
Manage customers billing
View the website.
Manage account.
Request for reservation.
Cancellation of requests.
View booked rooms
Manage accounts/ room information
Table 4: Access Controls
Minimum
Recommended
Mobile Processor of
Processor
Operating System
Windows XP SP2
Windows XP SP3 +
Memory
1G Ram
2G Ram
Internet Speed
512kbps
5mbps
Database Server
MySQL 4
MySQL 5.5 +
Browser
Mozilla 7 / Chrome 13
Mozilla 9 + / Chrome 15 +
mysql-connector-odbc-
mysql-connector-odbc-
3.1.14-win32
3.1.14-win32
Database Connector
Evaluation Results
The performance of the website was evaluated in terms of Content, Design, Functionality
and Originality based on Philippine Web Awards Criteria. There were 50 respondents who
evaluated the website composed of 25 CHM students and 25 IT students.
Page | 48
Table 6 summarizes the evaluation result showing the mean per criterion and the
corresponding qualitative interpretation. The table also presents the overall mean resulting from
getting the average of the mean of the five criteria.
The system received a positive overall mean rating of Very Good, showing that it had a
impact to the evaluators. The evaluation for originality scored for the highest mean amounting to
4.08, achieving a very good rating. This shows that the concept of the system appealed the most
to the users.
The content criteria received the lowest mean amounting to 3.96, which is nevertheless
equivalent to a very good rating and shows that the content of the system is in correspondence to
the capstone processes.
Table 6: Summary of Evaluation Results
Criteria
Mean
Qualitative Interpretation
1. Content
4.22
Very Good
2. Design
4.10
Very Good
3. Functionality
3.96
Very Good
4. Originality
4.05
Very Good
4.08
Very Good
Overall Mean
Page | 49
CHAPTER 5
SUMMARY OF FINDINGS, CONCLUSIONS AND RECOMMENDATIONS
This chapter presents the summary of findings, conclusions and recommendations based
from the results of the test and evaluation.
5.1 Summary of Findings
Nowadays in this generation every work is required to be done in an easy way to
efficiently use time and effort yet still having a productive report.
On the basis of tests and evaluation conducted on the content, design functionality,
technology used and originality, the following were the findings of the study. Integrating the
reservation system with a more modern Online Hotel Reservation and Centralized Billing
System and better software, information processed will become more precise, reliable, accessible
and secure, with the use of internet, interview and observation method the proponents suggest a
simple yet systematic implementation of an Online Hotel Reservation and Centralized Billing
System whose software will include modules such as home module, Registration and
Verification, Security, booking, Log-in, monitoring (calendar, rooms, confirmed reservation,
pending reservation, not completed and users/members account), repots, file maintenance,
FAQ/help and about module.
Page | 50
5.2 Conclusions
Based on the findings of the study, the following conclusions were drawn within the
limitation and scope defined in the study Online Hotel Reservation and Centralized Billing
System was developed for the College of Hospitality Management. The developed software
presented features that helped the College of Hospitality Management students in familiarizing
with an online hotel reservation system. The developed software served as a tool for the
instructors in teaching the basic operations of an Online Hotel Reservation and Centralized
Billing System to their students. The developed system also presents features and online security
to protect privacy and financial information of clients.
5.3 Recommendations
After having evaluated the findings of the study, the following recommendations were
hereby suggested: this system should be used by the College of Hospitality Management students
to give further knowledge about Online Hotel Reservation and Centralized Billing System.
Future researchers and developers can add modules and additional features as this system is open
for further improvements and developments because of the fast pacing changes in technology. A
follow up study should be conducted to determine the usefulness and effectiveness of the
developed system upon implementation.
Page | 51
APPENDIX A
Gantt Chart
Page | 52
APPENDIX B
Entity Relationship Diagram
Page | 53
APPENDIX C
Data Dictionary
Page | 54
APPENDIX D
Context Diagram
Page | 55
APPENDIX F
System Flowchart
REGISTER
CANCEL RESERVATION
RESERVED
PAYMENT/BILLS
INPUT DETAILS
LOGIN
LOGOUT
Page | 56
BEGIN
LOGIN
MAIN PAGE
Page | 57
APPENDIX G
Use Case Diagram
Page | 58
APPENDIX H
Sample Questionnaire
Category: (Check the box that applies)
Please indicate a check mark () under the column that best describes your responses for each item about
the Online Hotel and Centralized Billing System. Please use the rating below:
Numerical Rating
Equivalent
5
Excellent
4
Very Good
3
Good
2
Fair
1
Poor
INDICATORS
5
Ratings
3
CONTENT
1. Quality of content
2. Fits the nature and goal of the Web site
3. Accessibility of information
4. Accuracy of information
5. Organization of content
DESIGN
1. Layout and visual appeal
2. Color themes
3. Professional looking
4. Effective use of space
5. Site navigation
FUNCTIONALITY
1. Multiple Web browser compatibility
2. Multiple resolution compatibility
3. Fast Web page loading times
4. Working links
5. Working images
6. Working Web pages
ORIGINALITY
1. Overall Web site impact
2. Creative use of materials and tools
______________________________
SIGNATURE OF EVALUATOR
_____________________
EVALUATION DATE
Page | 59