Chapter1 To 5
Chapter1 To 5
Chapter1 To 5
CHAPTER 1
This chapter presents the Introduction of the research study and background
information of the research
INTRODUCTION
value for customers. Colleges and Universities in the City are held with high regards
as places for higher level of education and learning, preparation for a bright future.
Most of newly graduate students in High school from provinces to the city are
identified to into several categories like job seekers or workers, travelers, tourist and
more.
Staying in the city requires an immediate family member to stay with it could be
belongs, students will prefer to stay within the vicinity of the campus they will study.
Job seekers or workers may choose to stay in a place near their workplace, while
travelers and tourist alike may stay in hostels or hotel. These days, there are several
factors to be considered in looking for the place to stay for years for students and
Since every traveler has different needs Online Hotel Transaction of Big Bro
House Hotel and Events Place in Cubag Cabagan Isabela one of the good hotel in
2.https://www.inettutor.com/source-code/review-of-related-literature-and-studies-of-hotel-reservation-
system/
Saint Ferdinand College 2
College of Information Technology
Centro, Cabagan Isabela,
Cabagan Isabela when searching for a place to stay, it is important to look for a great
deal and a great place to be. It is a tiresome task with the numerous deals and
Before choosing for a place to stay. There are many factors for a traveler to consider in
selecting a good place. One of it is the type of accommodation to get that will suit the
budget. Some of the travelers consider getting into a five-star hotel as long as they
have the money but some of them are just looking for inexpensive temporary shelter to
The Encyclopedia refer the word ‘Hostel’ as an old name for an inn and was
later on used to illustrate a building that provides lodging for students and some other
groups. The word “hotel” and “hostel” came from the same origin, coming from the
English language from and old French hostel and from the Late Latin hospitable,
which indicates place for rest. Later “hostels” was use for a place where students can
stay for better learning. Hostels refers to a building in which board and lodging is
looking for a room that provides lodging for a short-term basis or sometimes willing to
share a room for sociable experience. Rooms can be mixed for male and female
together or separately, although private rooms may also be available. The essential
accommodation, in the past consists of a room equipped with modern efficiency like a
1...https://www.academia.edu/14925294/Hotel_Information_with_Online_Transaction_and_Billing_System_for_Yuj_Inn_Hostel htt
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College 3
College of Information Technology
Centro, Cabagan Isabela,
well-organized reservation system with ease in accessibility which aid ensuring a well-
Company Profile
Established on July 06, 2020, Bahay Ni Kuya (Big Bro House) Hotel was
created by a businessman in Cubag, Cabagan, Isabela. The hotel is owned and
managed by Mr. OrlandoC. Marayag he decide to name Bahay ni Kuya (Big Bro
House) Currently the hotel has 12 rooms across multiple select services, extended
stay, mid-scale, family room single bed and walk-in room previously full services
event weddings, birthday parties and more. He decided the name Bahay ni Kuya (Big
Bro House) because he is the eldest in their siblings. One of the hotel main goals is to
provide a homelike ambiance and a feeling of a Filipino warmth and hospitality to their
and will continue to grow under the management of his family. The Reservation
System of Bahay ni Kuya (Big Bro House) Hotel us manually done. Tellers staying in
the reception are dependent on incoming calls for a room. Calls into written entries on
their monthly calendar for reservation.
Vision
Bahay ni Kuya (Big Bro House) tocreate personal experiences for our guests
that they will treasure for a lifetime and to be the destination of choice for our
discerning guests, members, associates, communities.
Mission
Bahay ni kuya (Big Bro House) with its unique sense of place, is devoted to
creating enduring relationships with our guest and members by providing highly
personalized services and gracious hospitality in an informally elegant setting. This is
our hotel mission statement
1...https://www.academia.edu/14925294/Hotel_Information_with_Online_Transaction_and_Billing_System_for_Yuj_Inn_Hostel htt
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College 4
College of Information Technology
Centro, Cabagan Isabela,
STEVENS MORATILLA
(MANAGER)
JOAN ALIGATO
(LAUNDRY)
Figure 1; Organizational Chart of Online Hotel Transaction System of Big Bro House (Bahay Ni Kuya)
1...https://www.academia.edu/14925294/Hotel_Information_with_Online_Transaction_and_Billing_System_for_Yuj_Inn_Hostel htt
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College 5
College of Information Technology
Centro, Cabagan Isabela,
Theoretical/Conceptual Framework
The hotel industry is a business venture for the owner and solace for the traveler
and/or tourist. It needs physical effort for you to get a room and it needs a lot of time
to search for a good room that can satisfy your needs. In this study. The researchers
realized that booking a hotel room consumes a lot of time and energy. This study took
enable customers choose the room they wanted after they experienced a virtual tour.
Research Paradigm
Big bro House Hotel uses manual transaction from customer’s reservation.
Researchers would like to incorporate information technology with the use of the
internet and empower business process of the Hotel.
1...https://www.academia.edu/14925294/Hotel_Information_with_Online_Transaction_and_Billing_System_for_Yuj_Inn_Hostel htt
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College 6
College of Information Technology
Centro, Cabagan Isabela,
Accounts
Name
Username
Password
FEEDBACK
Figure 2. Conceptual Paradigm Input-Process-Output of Online Hotel Reservation System of Big Bro
House Hotel and Events Place.
1...https://www.academia.edu/14925294/Hotel_Information_with_Online_Transaction_and_Billing_System_for_Yuj_Inn_Hostel htt
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College 7
College of Information Technology
Centro, Cabagan Isabela,
The researchers will support and mange online hotel transaction and services in
Big Bro House and Events place in Cubag Cabagan Isabela to developed a
Computerized Web-Base of the System to provide better services to the
customers.
1. What is the status of the existing transaction system of Bahay Ni Kuya Hotel
in Cubag Isabela?
2. What are the processes involved in the existing system of Bahay Ni Kuya
Hotel in Cubag Isabela, what are the problems encountered in the existing
system if Bahay ni Kuya Hotel?
The objective of this study is to have an electronic-based transaction of Big Bro House
Hotel and Events Place since they are still using manual system through records
books in their transaction and payments.
1. To identify the status of the existing system of Big Bro House in Cubag Isabela.
2. To understand the processes involve in the existing system of Big Bro House in
Cubag Isabela.
3. To recognize the problems encountered in the existing system of Big Bro House in
Cubag Isabela.
1...https://www.academia.edu/14925294/Hotel_Information_with_Online_Transaction_and_Billing_System_for_Yuj_Inn_Hostel htt
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College 8
College of Information Technology
Centro, Cabagan Isabela,
This part discusses the significances of creating the system to the Big bro House
And Events Place. Research strongly believes that the system will be beneficial to the
following.
Big Bro House Hotel – The significance of this study to manage the guest or the
Customers to reach their hotel using the Internet. In addition, this can help them
doing work more easily and precisely
The Customers – They can view the amenities, facilities, package deal and offer of the
Hotel using the computers. They can also see the pictures of the place, their package
offer, rates and announcements.
Administrator – The one who will administrate or handles the system can add more
system users that grant permission to it
The Researchers –This will serve the researchers to implement what they have
learned and improve their skills that will help them to finish the study.
The Future Researchers - This will serve as guide the future researchers and
help them in making their own research study.
1...https://www.academia.edu/14925294/Hotel_Information_with_Online_Transaction_and_Billing_System_for_Yuj_Inn_Hostel htt
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College 9
College of Information Technology
Centro, Cabagan Isabela,
Definition of terms
1...https://www.academia.edu/14925294/Hotel_Information_with_Online_Transaction_and_Billing_System_for_Yuj_Inn_Hostel htt
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College 10
College of Information Technology
Centro, Cabagan Isabela,
Costumers – talks about the people who will check in the hotel.
Researchers – the one conducts the study and will be developing the
computerize system of the business.
Acronym
OHTBBHH – Online Hotel Transaction of Big Bro House Hotel.
BBH – Big Bro House.
OHTBBHHEPCCI – Online Hotel Transaction of Big Bro House Hotel and Events
Place in Cubag Cabagan Isabela
1...https://www.academia.edu/14925294/Hotel_Information_with_Online_Transaction_and_Billing_System_for_Yuj_Inn_Hostel htt
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College 11
College of Information Technology
Centro, Cabagan Isabela,
CHAPTER 2
This chapter presents the related literature and studies about the current business
that the researches choose where they will continue.
Foreign Literature
facilitate cross border consumer activity. The Internet has enabled hotels to contract
directly with a huge number of potential customers. It has also revitalized the role of
agents and lead to new type of agent, the web agent or travel gate, selling a far wider
range of accommodation on behalf of a far wider range of hotels. However, while online
booking has increased the range of offers available, there are also some emerging
the number of bedrooms remaining at the specified price, and to display a summary
off contract terms, relating to cancellations by the consumer and hotel. They also
included that online transaction systems must display the final price of a hotel room
This study proposes to improve legal protection of customers with regard to online
ps://www.academia.edu/27474384/Chapter_2_Review_of_Related_Literature_and_Studies
Saint Ferdinand College
College of Information Technology
Centro, Cabagan Isabela,
information about the number of rooms that are available for reservation. In addition,
a contract terms and conditions about cancellations will provided for customers.
Hotels can also compete by offering what third party services offer (ease of access
through the internet) but doing it better and more effectively themselves. Large
numbers of travellers are now booking their rooms through hotel websites, many of
which offer three-dimensional views of rooms, public areas, spas and other amenities,
giving clients the ability to see what they are booking even more clearly that they
Asupra, (2016), studied an automated system of billing and reservation for “Pearl
Manor Pension House” Incorporated. After a careful study by the researchers it has
been found out that the employees’ encounters problem with their present system,
study of the current system of Pearl Manor Pension House, Incorporated, the group
came with a conclusion to; automate their system. The automation of the system will
give advantages to the company because it will make the computation of bills a lot
easier and more accurate. Processing is faster and more convenient for both the user
and clients. The results of interviews and research study that was conducted by the
system of the company. The system will be the one responsible to process all the
transactions.
Cagalawan, (2003), studied and proposed an online hotel reservation for Bacolod
Executive Inn. The findings of the study stressed that some problems exist in their
2.https://www.inettutor.com/source-code/review-of-related-literature-and-studies-of-hotel-reservation-
system/
Saint Ferdinand College 13
College of Information Technology
Centro, Cabagan Isabela,
and observation to the existing reservation procedures, the group came with a
conclusion that the Bacolod Executive Inn particularly the reservation must be
developed through an online system for their better service. It will provide advantages
in the part of the establishment because it will increase the number of customers,
minimize the workload of the personnel and the generation of reports on time, and will
provide promotion to the establishment through the website that will highlight the
quality of service they offer. After a detailed study, the researcher’s recommendation is
based on the accurate and relevant information from the data gathered. The proposed
on-line reservation system for the Bacolod Executive Inn provides better service to the
information from the data gathered. It could improve its current operation as soon as
Local Literature
The Web based Information System with online booking, online payment is
designed to help Nippon travel, and tours improve their manual system thru internet
website. The system will be created for booking clients reservation and receiving their
payment thru internet. The information needed shall include the client's desired date,
Destination, preferred airline and the total amount due and payable to Nippon Travel
Agency. The system will be protecting by data access control. Which will restrict the
unauthorized users having access to the database by limiting their access to certain
Saint Ferdinand College 14
College of Information Technology
Centro, Cabagan Isabela,
databases. It retrieves data information for further use. (Cruz, et al, 2017)
commerce, which is why they decided to accomplish a system that would contribute as
an immense help in managing and improving St. Vincent Cottages Resorts (SVCR)
reservation system. The system that they implemented was an online transaction with
billing system. The system was design to serve and to provide the guests with a room
transaction via online. The system that they developed contains all the compulsory
information about the resort itself, the room reservation, room types, room rates,
services and facilities. Moreover, by means of Internet connectivity, the guest would
have an easy way in accessing the system for them to have their reservations booked
As a conclusion, the system designed for Nippon Travel and Tours and SVCR
is almost similar to the proposed system of the proponents, which also has backup
features, restore, Databases and information about the rooms of the hotel that
customers can transact. This article helped the proponents understand more about
Online Hotel Transaction System (OHRS) is efficient and brilliant software, yet
IL is easy and uncomplicated to use. OHRS grants complete authority and power on
hotel or motel room booking over the internet. This entails that one can accumulate all
guest payments; enter own room descriptions, facilities, rates and allocations into the
hotel's web site and close the sale without more ado. There are several benefits of
OHRS. It makes the reservation process computerized and thus helps one to
available inventory and complete an online booking form making the reservation
OHRS assists hotel's guests and agents with different payment options such
as credit/debit cards. The system can track hotel's performance on a regular basis as
all information concerning payments is updated online and sent to the reservation
confirmation, where the system will generate a confirmation code that will be sent to
the customers email address for the completion of their transaction process.
Foreign Studies
Hotel CRS stands for hotel central transaction system and is commonly used
in resort and hotel industry. CRS is a computerized system that revolves around
storage and distribution of information concerning resorts, hotels and host of lodging
facilities. CRS as a tool is used to reach the global distribution system or GDS along
with internet distribution system from a single point system. Hotel managers use this
tool to manage their online sales and marketing revenues. Information includes room
information, graphical information in the form of video, pictures and detailed hotel
information like address, phone and fax numbers and geographical code information.
(Matthew, 2013)
Saint Ferdinand College 16
College of Information Technology
Centro, Cabagan Isabela,
This article discusses about the items needed to create a reservation system.
This helped the proponents understand and learn about the information's that can be
(Bituin Abi, 2017) Online Transaction System. Short term base lodging is
the main reason that a hotel has been established. In the Philippines, wherein many
foreign people go and have a vacation, hotel is always their first destination to have
foreigners visiting the Philippines for a vacation, a common sight is the establishments
As a conclusion, the proponents will provide all the information that can help
Flight Transaction System makes the life of passengers very easy, as they do not need
to stand in queues for getting their seats reserved and they can easily make
transaction on any airline just from a single system. On the other hand, it also
removed an extra burden from the Airline Department as most of the passengers and
travel agencies use this service instead of making reservations from the counters. With
the help of the system, customers can view al1 the different flight's availability with
different timings for a particular date and it also allows them to reserve a seat, cancel
a transaction or modify it. The only problem with the system is that it does not allow
the passengers to change the particular part of his or her transaction. The data is
updated immediately to the server because at the same time many users will be
transaction the seats from different places. So each request will be send to the central
server by the software and the server will check the request. If the request can be
Saint Ferdinand College 17
College of Information Technology
Centro, Cabagan Isabela,
granted, the server will give a positive response to the user or else it will indicate an
error message that will be sent back to the user. (Bhargava, 2017)
This article is almost similar to the proposed system of the proponents; the only
difference is the system used in the article is for an aviation company while the
proposed system of the proponents is intended for a hotel. The proponents shall
develop a system that updates every time when a new transaction has been made.
Local Studies
The website of The Theodore Hotel gets an upgrade with the recent addition of a direct
within minutes. Guests of the hotel can now enjoy a quick, easy reservation process,
thanks to the recent launch of a booking engine on the Tagaytay hotel's website.
Choice and length of stay. A 10% deposit through credit card secures the transaction
and automatically sends confirmation of bookings via email. This innovative way of
reserving accommodations saves time and energy that guests would normally spend
using more traditional means of booking rooms at the hotel. (Pelayo, 2014) As a
conclusion, the Theodore Hotel equipped itself with online transaction system that can
help them promote their services, and at the same time it can help their customers
lessen the time they spend booking rooms at their hotel. The proponents will design a
system that can help Yuj Inn Hostel promote their offered services.
significance for the convenience of the employees and for faster transactions. It must
Saint Ferdinand College 18
College of Information Technology
Centro, Cabagan Isabela,
also reduce time consumption and therefore cut off the hassle for the personnel in
charge and also for the guests. By this, they were able to find some alternative ways to
management, and online reservation system, implementing online payments for the
generate reports. This solution will assist the personnel in charge in the front desk in
terms of fast transaction, secured data archiving, and generating fast sales report.
The article also includes programs that can help the personnel in charge in the
front desk on how to use their proposed system. Thus, the proponents considered
providing user's manual and trainings for Yuj Inn Hostels employees. The user's
manual and trainings can help the employees understand the processes of the
CHAPTER 3
This chapter presents the methodology that the researcher used. This chapter also
contains the techniques, methods and procedure that the researchers employ to
Rapid Application Development (RAD) is the development life cycle designed to give
much faster development and higher-quality results that those achieved with
RAD generally incorporates short development cycle user see the RAD product
quickly
RAD involves user participation thereby increases the chance of early user
community
systems analysis phase of the Systems Development Life Cycle (SDLC). Users and
Managers discuss. Users and managers discuss and agree on business needs, project
scope, constraints, and system requirements. It ends when the team agree on the key
In the phase, the researches discuss on what website looks like website looks like
should and what are the features can be integrate in the website. The researches
gathered information about the hotel. The researchers also discuss what the scope of
User design phase– during this phase users interact with the system analysis and
develop models and prototypes that represent all the system processes, inputs and
outputs.
In this phase, the researchers create a prototype of the website to be present for the
respondents. This will help the researches most of demands and expectations of the
respondents.
Construction Phase – focuses on program and application development task like the
SDLC. In RAD, however, users continue to participate and can still suggest changes or
improvement as actual screens, or reports are developed. It’s task are programming
The objective of the researches will modify the prototype according from user’s
Cutover phase – Resembles the final task in the SDLC implementation phase,
including data conversion, testing changeover to the new system, and user training.
Saint Ferdinand College 22
College of Information Technology
Centro, Cabagan Isabela,
The new system is built, delivered and placed in operation much sooner.
The objective of the respondents is to make a website that will suit the demand of the
To get enough and accurate information about the subject matter the researches
Observation
The Hotel is very nice. Staff is very co-operative. Good service. The rooms were
Internet Surfing
Library Research
This technique was used whenever the researchers find the difficulty in
The researchers interviewed Mr. Orlando C. Marayag first to know what the
content and the design of the website should be. After that, the researchers
Kuya Hotel and asked Mr. Marayag suggestions and other ideas. Mr. Marayag
liked the sample website that was presented and agreed to the design or the
website.
Saint Ferdinand College 23
College of Information Technology
Centro, Cabagan Isabela,
CHAPTER 4
DISCUSSION OF FINDINGS
Hardware Requirements
In the development of the system, a laptop was used with the following
specification: processor Intel Core i3-7020U @ 2.30 GHZ and 4.00GB of RAM
Software Requirements
Software requirements used Windows 10, 2019 (64-bit) Operating System, Sublime
Text as front end (programming language) and MySQL XAMPP bersion 7.4.27 as its
back end (database implementation)
CHAPTER 5
This chapter present the central matters of summary end and suggestion end and
suggestions that are drawn from the investigation
Conclusions
In light of the discussion and discoveries of the study the accompanying ends were
made:
1.The Big Bro House Hotel Online Transaction has successfully met its functional
requirements such as storing if guest records, computation and storing of transaction
of each guest and calculating bills.
2. The Big Bro House Online Transaction System is gotten in putting away information as
it was given a username and secret word in administrator page
3. The Big Bro House Online Transaction System is seen to be practical and usable
Recommendations
In view of the discoveries we have accumulated, the following are recommended:
1. The future researchers who will undertake similar study may be advised to include
the online payment and printing of receipt for enhancement of the study
2, Prior to the use of the System, clients should go through shorts preparing to make
them more proficient in utilizing the System
Saint Ferdinand College 25
College of Information Technology
Centro, Cabagan Isabela,
APPENDICES
Start/End Symbol
process.
Decision Symbol
diamond.
Saint Ferdinand College 26
College of Information Technology
Centro, Cabagan Isabela,
Connector Symbol
been placed.
Input/Output Symbol
Represents material or
information entering or
product (output)
Database Symbol
Document Symbol
START
Saint Ferdinand College 28
College of Information Technology
Centro, Cabagan Isabela,
YES
NO
START
HOME
Yes Home Page
A 6 1
No
FEATURES
Yes 2 Features Page
No
SERVICE
Yes Service Page
3
No
CONTACT US
Yes 4 Contact us Page
BOOK NOW
Yes 5 Book Now Page
A VIEWING OF HOMEPAGE
BACK?
YES
MAIN
NO
5
Home Page
B
FEATURES
2
Saint Ferdinand College 31
College of Information Technology
Centro, Cabagan Isabela,
YES
5
NO
SERVICES
3
Saint Ferdinand College 32
College of Information Technology
Centro, Cabagan Isabela,
YES
5
NO
CONTACT US
VIEW OF CONTACT US
A PAGE
Saint Ferdinand College 33
College of Information Technology
Centro, Cabagan Isabela,
YES
5
NO
5 A YES
SUBMIT NO
? DATAB
INPUT DATA
ASE
YES
END
A
End? NO
EVENTS PAGE
A 6
Saint Ferdinand College 35
College of Information Technology
Centro, Cabagan Isabela,
NO
Submit
Data
Yes
base
NO YES
Print
NO
A
End?
End
START
A LOG-IN
YES
Correct?
G
NO