Online Reservation and Billing System for Riverside Resort and Rest Inn

People came unexpectedly in a resort especially during summer. Enable to avoid an overcrowded scene, we came up to an idea that can reserve and schedule a room for the customer and at the same time can promote the resorts beauty, hospitability and reliability.

Computers are commonly used worldwide it can do a lot of things like: storing files, sharing files, editing files, computing income and as a medium of amusement. It is necessary for a business to have such device the catch here is to maximize the use of hardware and software of the computer to make things easy for the resort in reserving and advertising. With the help of the internet, creating an on line reservation and at the same time an advertisement in a web site can do the trick. Via internet connection, you can access information on the web site that we would create and the customer will fill-up a user friendly step by step procedure in order to reserve and schedule them a place to stay.

A Resort basically a place used for relaxation or recreation, attracting visitors for holidays or vacations. Resorts are places, towns or sometimes commercial establishment operated by a single company. The term “Resort” is now also used for a self-contained commercial establishments which attempt to provide for most of a vacationers wants while remaining on the premises, such as food, drink, lodging and a comfortable amenities. On the other hand, a resort is not merely a commercial establishment operated by a single company although it was become more common. Resort probably was one of the place where vacationers or travelers can relax and enjoy the beauty of surroundings, at that point, they will be encouraged to reserve on the resort but they had no enough time or less time to go inquire on book for the reservation.

Through online reservation system a number of benefits that make reservation preferable for arranging a trip over the computer, with online reservation system the customer knows the information and gets reservation wherein it saves time and energy so customer are able to book or reserve all that they deserve and be able to plan their reservation quickly without leaving their home all they need is an internet connection. The system keeps the best alternative solution to once stagnant method for manual operation. This process mutually enhances the technical capability of the resort in the pursuit of the business world. (http://www.studymode.com).

Statement of the problem:
The problem of the study is making an online reservation and billing system for Riverside Resort & Rest Inn. Storing data is a problem for Riverside Resort because they only store information in a piece of paper and stored in a shelf or cabinet making it more prone to errors can be misplaced and can be damaged easily. To make storing data easy , Online Reservation and Billing System is proposed to lessen or eliminate data lose,damage and errors.

As stated in Statement of the problem number 1, storing data is hard and easily misplaced,damage and lose by the employee, so generating data and information is hard aswell. Without proper generating of data, misleading of information is more prone.

Online reservation and billing system is proposed to lessen the hustle of reserving of costumers. Because some costumer does not have the time to reserve by going to Riverside Resort. So to lessen the time, energy, and money consumed, Online reservation and billing system is proposed.

Importance of the study:
The development of the Online Reservation and Billing System for Riverside Resort and Rest Inn will be beneficial to the ff. people:

Aspiring Researchers
This study can benefit the knowledge needed by future researchers because they can use this as a foundation of their research or a reference to their work.

Cashier
The cashier receives and holds the income of the resort and delivers it to the owner. By using this kind of system, it can avoid a shortage of their income. Automatically, it can register to the computers database the exact information in the registration of the customer. It can lessen the job of the cashier. Customer

The customer always wanted a fast, reliable, safe and polite service. Using this kind of system, Online Reservation and Billing System is the better way to show a fast, reliable, safe, and polite service. By using its user friendly step-by-step procedure in registering and paying for a reservation the customer doesn’t need to fall in line in front of the cashier inside the resort and can take their time in choosing a room to stay. Online customers can get their online receipt that will be printed at the resort they just need to get the receipt number given to them at the site enable for them to get the receipt at the resort. The receipt number will serve as their ticket to enter the resort.

Owner
The owner can now just sit back and let the computer do the talking. With the use of the Online Reservation and Billing System at the same time it can promote the business of the owner by putting a little advertisement that can please the eyes of the people.

Objectives of the study:
The objective of the study is to create an On-line reservation and billing that:
* can reserve a customer a place to stay;
* can be use as a medium of billing;
* shows an advertisement that can please a customer;
* can store data ; and
* can maximize the use of computers.
Scopes and Limitation:

The system can add, update and delete reservation of customer. The system use log in system so that the authorized personnel can only manipulate or used the said system. If the reservation is been cancelled or updated, the system will automatically update the reservation with the use of a serial key given to customer, they will use the given serial key to update or cancel reservation.

The limit of the system is payment for the reservation and the specification needed for the computer. Payment shall be held at the cashier inside the resort and the computer shall have internet connection.

Definition of Terms:

Open Source. – a philosophy that promotes free redistribution and access to an end product’s design and implementation details MySQL.– a commonly used open source relational database management system (RDBMS) as of 2008 that runs as a server providing multi-user access to a number of databases. RDMBS. – A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. PhP. – is a widely used general purpose scripting language that is especially suited for Web development and can be embedded into HTML. HTML. – is the main markup language for displaying web pages and other information that can be displayed in a web browser. NOTEPAD. – a plain text editor used as an HTML and PhP editor. DBMS. – (Database Management System) is a software package with computer programs that controls the creation, maintenance, and use of a database.

CHAPTER 2
Related Literature
Existing manual system have been change since the age of computer. In fact, few resorts have developed an automated system which requires the use of computer. Internet connection has done a big help for transacting business around the globe. In the development of the “Online Reservation for Riverside Resort and Rest Inn”, reviews from selected system studies were evaluated by the proponents help broaden the background of this study. Related literatures are as follows:

Database System
A database system is a term that is typically used to encapsulate the constructs of a data model, database management system (DBMS) and database. A database is an organised pool of logically-related data. Data is stored within the data structures of the database. A DBMS is a suite of computer software providing the interface between users and a database or databases. A DBMS is a shell which surrounds a database or series of databases and through which all interactions take place with the database (http://en.wikipedia.org).

Billing System
A billing system is a combination of software and hardware that receives call 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 (http://www.billingdictionary.com). Software designed to handle time and billing tracking as well as invoicing customers for services and products. Billing software can track the hours worked by employees as well as expenses associated with projects or clients. Most time and billing software applications also create billing cycle reports to display information such as hours worked, expenses incurred, how much to bill clients, and which clients owe money for specific projects (http://www.webopedia.com).

Online Reservation
The application of modern information technology dominated so far by the use of Internet websites and online reservation systems, gives competitive advantage to other with same establishment. However, the potential competitive advantage can be transformed into real advantage if only the websites have proper design. As a result, the advocator conducted research on the facts related to the system that might be helpful to its development. (http://www.studymode.com).

Online Billing and Reservation System for Private E Resort
(Belloga, Malicsi, Supapo, March 2011)

The Private E Resort’s Online Billing and Reservation System were developed to remove inaccuracy due to the existing manual system. The reservation officer and the administrator can now enjoy having an online system. They can easily maintain and improve their system by having a database that can be easily updated.

The Online Billing and Reservation System for Private E Resort will provide more efficient, less time consuming transactions that will benefit not only the clients but the reservation officer and others as well.

The Study aims to minimize the complicated work of the reservation officer. Through the use of Microsoft SQL server 2005 for the database, the reservation officer can now generate different types of reports.

Villa Julia Resort – Online Reservation and Billing System (Casas, Capili, Hernandez, May 2009)

Villa Julia, a resort located at By-Pass Silang, Cavite, uses a manual reservation and billing system. With it, they encounter errors that hinder the operation of the resort smoothly. These problems are data redundancy, incorrect data accumulation and data vulnerability.

The proponents developed this study to help eliminate such problems. By adapting to modern trends like an online reservation and billing system, it will not only improve the company’s business but also add to the significant functions necessary for the industry.

Online Reservation with Billing System for Villa Felicidad
(Benamir, Berin, Gallano, March 2009)

Villa Felicidad Resort was a manual system in billing and reservation. As a result, the resort encounters inefficiency in most transactions and operators. This problem is caused by information redundantly copied, inaccurate information and data tampering.