Computerized Hotel Reservation System Capstone Project Document

Introduction

Hotel La Je-Ann was an establishment which you could stay whole day or overnight for a rest when you were in a group or you solitary. The establishment for the reservation used manual system through searching and writing down the information about the reservation in a logbook. There were customer complaints regarding the time-consuming procedures that were being done in the reservation process.

At the present time, manual works were being computerized due to the technology that facilitates others to have a high-technology system. Because of this things, work became faster and easier. Information being retrieved is more accurate and steadfast. Procedures become more well-organized and effective.

Regarding that, the proponents helped the management to have an updated system that could helped the company to reduced time consumption and ensured accuracy of computing the payment without errors automatically and for searching the rooms for reservation.

The proponents concluded that automation of manual works like the hotel reservation system would give different advantages to the users. Technology should be applied so that we could make this work effortless, manageably and accurately.

Statement of the problem

The problems identified are as follows:

The reservation process is slow.
Storing and searching of data is very time-consuming.

Objectives

The objectives of this study are as follows:

To speed-up the reservation process of the hotel.
To help the customers and the management to improve the process and to speed up the storing and searching of data.

Scope and Limitation

The scope of the study is concentrated on the hotel reservation process. There is a database which contains all records of the person who had made a reservation.

The user can use the functions save, cancel and back. User can search the person who is in the reservation slot.

The proposed system is all about the hotel reservation system as well as reports. The proposed system will not include the problem of their monitoring system of the payment process.

Significance of the Study

Today, manual works are already being computerized. That is the reason why the proponents have decided to develop the computerized hotel reservation system in order to expedite the reservation process and to increase the effectiveness in data storing, recovery and accuracy for the computations of the bills.

The main users of the proposed system are the receptionist for they are the one who will conduct the process of reservation.

Definition of Terms

For better understanding of the terms used in the study, the following are defined:

Database

– It is an organized by fields, records and files

Reservation

– An agreement to hold on something back, as a hotel room, restaurant table, etc., for use at a particular time

Password

– Form of secret authentication data that is used to control access to a rescue

Visual Basic 6.0

– It is an event driven programming language and associated development from Microsoft for its COM programming model.

Related Studies

Reservation is an arrangement to secure accommodations at a restaurant or hotel, on a boat or plane, etc. The record kept or assurance given of such an arrangement: Sorry, the hotel has no reservation under that name.

Local Studies

The development of the computerized reservation system of Junction-inn, the proponents design this system to be able to help their reservation department and to the person in charge to make reserve and record keeping. The proposed software will give an automated for their reservation that will help them to speed up.

Foreign Studies

The Opera Reservation System (ORS) centrally managed computer reservation manage computer reservation system is at the heart of the hotel industry’s First enterprise – wide inventory and reservation management System. The ORS hotel Reservation system is designed for seamless integration with the entire opera product family- the opera customer information system (OCIS) the opera property management system, opera sales and catering, and opera sales force automation. This centrally managed computer reservation system offers central reservation agent and global sales staff the tools to maximize booking and increase revenue in any size chain or multi- property environment. ORS easily handle all types of reservation.

Data Analysis

Based on the proponents analysis on their local and foreign studies, the local studies of the reservation system of Tanauan, Batangas is the proposed system wherein the purposed of this is to develop and to make it accurate and efficiently the reservation system into a more advance and sufficient system. This proposed system of the hotel is also related to the proposed project of the proponents. In the foreign study, it tells us that there

Finding

After the observation of the proponents found out that the said studies has its own purpose. The main purposed of the study is just to have a computerized Reservation System where the customer can easily access on their system and can build a better interaction between the user and all the people who had the consent in the said system.

Local of the Study

The target local of the study is Hotel La Je-Ann at Sambat, Tanauan City, Batangas. The proponents resolute to propose a Computerized Hotel Reservation system in the said hotel because of its slow transaction process of the reservation. It was found that there establishment as of now is experiencing problem due to the manual searching of the rooms for reservation that consume a lot of time. There is a more possibility that the customer will be annoyed in waiting for the process.

Methods for Data Gathering

The proponents make use of different methods for their data gathering. They used the library and unpublished thesis. They also conducted interview.

The proponents interviewed the manager, the staff and the selected employees who are involved in the process of reservation.

Methods for Software Development

The proponents used prototyping in the developing of their proposed hotel reservation system. In this type of software development, the user are shown a working model or a prototype which they can interact with. The users can transfer on the other modules and suggest modifications in the proposed system. Through this procedures can be easily change making the software development rapid.

Project Selection and Planning

The end result of the study made by the proponents within the surrounding area gave the project team an idea of what is in demand and necessary system. The study team created a plan on how to gather additional data whether to pursue the project and the proponents set a specific time and resources needed for the system implementation. They considered also the cost that is going to spend during the project development.

Data Gathering Procedures

The proponents used interview method in data gathering procedures. The objective of this system interview is to know the reservation process of the establishment. This study was also conducted in order to identify the strengths and weakness of the current system.

The researchers gathered related lectures and studies from the library and unpublished thesis that contains information regarding the problems.

Data Analysis

After the proponents had completed the interview the result was been analyzed. Frequently means nothing more than summarizing the data. But it also involves development at the system flowcharts, data flow diagram and program flowchart.

System Design

Based on the result of the interview and studies made by the proponents, Hotel La Je-Ann located at Sambat, Tanauan City, Batangas must have the computerized generated hotel reservation system.

System design includes, what will be the process of data and how it works. System flowchart, data flow diagram, program flowchart; data were identified and created. Database design was also included. It also gives the picture of what will be the Graphical User Interface (GUI) of the system.

System Interface

After the data was being analyze and system design was identified, next stage is the creation of the system interface or Graphical User Interface (GUI). System Interfaces is the physical view of the system wherein the user is working on.

Description of the Proposed System

The proposed system, Computerized Hotel Reservation System of Hotel La Je-Ann aspires to have an effective, efficient, consistent and faster reservation process. The system will help out in having an improved way of reservation system.

Context Level Diagram

Context Diagram