Online Hotel Reservation System Capstone Project Document

Introduction

Technology in our society becomes more complex over years through mans development of a new technique that could meet the ever-increasing needs in all aspects of information.

The study of System Analysis and Design (SAD) involves preliminary investigation through analysis of the existing system being used in the Reservation of Palazzo de Laoag Hotel. The researcher conducted this study at the said hotel with the end in view of coming up with a system that would facilitate the flow of transactions particularly in its reservation in as much as the present system is purely manual in nature.  The study involves the Resident Manager and the front desk personnel, as they are the front liners in this business establishment. Moreover, they stand, as the partners of the researcher who shall in the end, be the ones to implement whatever good this study shall deliver.

Conceptual Framework Of The Study

Computerization program deemed the best alternative solution to once stagnant method of manual operation. The process virtually enhances the technical capability of companies and schools in the pursuit of their business venture. This study was further conducted to be able to study the organizational structure of the company and make research on its history, function, objective, policies, system and procedure, duties and responsibilities of each personnel, to familiarized the research with the process flow of the present system, to propose an online system for the company and to develop and implement the proposed system.

It include here also the Systems Development Life Cycle. This chapter presents the methods that the researchers have undertaken in the conduct of the study with the system development life cycle as basis.

Conceptual Framework

Conceptual Framework

The first step is the Project Identification and Selection wherein the researcher selected from among the system proposals to be presented. The proposed system that was chosen was Online Hotel Reservation Of Palazzo de Laoag Hotel, Laoag City.

The next step is the Project Initiation and Planning wherein the researchers provided a letter of permission to the Manager of Palazzo de Laoag Hotel where the study was conducted. A receive copy was given back to the adviser as a proof of permission from the manager of the hotel. Initial details about the project were discussed with her. The researchers came up with a specific plan to follow during the course of the study.

The step that followed is the Analysis. In this step, the researcher will discuss how to determine the system requirements through interview, observation, and review of documents, forms and others.

Since the study focuses on the Online Reservation of Palazzo de Laoag Hotel, actual interview with concerned personnel will be conducted. The researcher will visit the hotel several times and additional interviews will be done.

Interview is not enough to complete the research. Going to the library will be a great help to the researcher in the development of the study. The researcher will browse old theses in the library, magazines and books to gain more ideas and knowledge on the proposed system. Through this method, the researcher will be able needed information of the study.

Surfing the net will also help the researcher to know the latest and newest information about the study. In the analysis stage the researcher will come up with the flow of the proposed system from which the description of the proposed system will be based. The researcher in this phase will come up with the cost benefits analysis that describes such plan to acquire any hardware and system software needed to build or operate the proposed system.

The next stage is the Logical Design wherein the researcher came up with the dataflow of the proposed system. The researcher will identify all entities needed to in the system and design the forms and reports to be outputted using Visual basic.

Next is the Physical Design wherein the researcher used to came up with the sample screenshots to be designed using HTML (Hypertext Markup Language).

The implementation and maintenance stages are to accomplish during the system development period.

It also involve here the Input Process Output (IPO) Diagram,

IPO (Input Process Output) DIAGRAM

IPO

IPO

Statement Of The Problem

The following problems have delivered during the course of the study:

  1. How is the online reservation developed?
  2. How efficient and effective is the proposed system in terms of the following:
  3. In minimizing the time and effort of the personnel concerned in reservation transaction?
  4. In facilitating reservation for the customer?

Significance Of The Study

  1. To the company:

The result of the study would provide more efficient and effective processing of data. It would also result to faster easier generation of the outputs. Hence, reports are submitted on time for timely decision.

  1. To the owner:

The study will provide all the necessary reports of all the transactions and will not cause the delay of submission of needed reports to the owner or the manager.

  1. To the researcher:

The conduct of the study helped the researcher to work   independently. She was able to practice her gained knowledge in System Analysis and Design (SAD).

  1. To the Customer:

This study will provide the customer a more secure and reliable transaction because it will save time and effort rather than doing it manually.

Scope And Delimitation

This study is limited only to Palazzo de Laoag Hotel. It covers the latest art of reservation which is online system. It also discusses significant features to the company involve as well as the customer. Payments are not done online, thus the delimitation.

 

Definition Of Terms

Information – Facts or knowledge obtained from investigation, study or instructions.

Record – Group of collected fields of information treated as a unit.

Data – Refers to the facts needed by the computer system in order to process and output necessary information.

Computer – An electronic device used for performing high-speed arithmetic and logical operations.

File – A collection of records that can be manipulated by people or machine.

System – A complete installation including peripherals, such as disk drive, monitor and printer which all the components are designed to work with each other.

Online – It is activated and ready for operation, capable of communicating with or being controlled by a computer.

Internet – It is an interconnected system of networks that connects computers around the world via the TCP/IP protocol.

Related Literature

According to Ray Nolan, CEO of Web Reservations International,

“Web Reservations International, a leading provider of online reservations for budget, independent and youth travelers, developed its first online store in 1999, and now handles over 2,000 customer transactions a day.

Its flagship site, www.hostelworld.com, provides real-time confirmed online reservations for over 3,500 hostels and hotels and almost 2,000 tours and activities worldwide. The site also provides comprehensive information to travelers including destination guides, discussion boards, travel stories and a personalized online itinerary builder. Other products sold online include bus and rail passes and a specially designed insurance product for backpackers and budget travelers.

Web Reservations’ first e-commerce solution was not robust enough to cope with the demand, and the reporting structure and support were poor.

Ray Nolan, CEO of Web Reservations International, explains: “Our customers are dotted all around the world and need to be able to log on to our site at a time convenient to them. Our store needs to be open and able to accept payments 24/7, and have the ability to cope with multiple simultaneous transactions.”

When looking at the options available in the market, Web Reservations came across WorldPay. Nolan was impressed by the reputation of the company: “WorldPay has been around for quite some time. It has offices and customers around the world, which we found reassuring. WorldPay were able to provide a solution that would fit in with our requirements, and they were also helpful and professional when we contacted them.”

Web Reservations already had an Internet Merchant Account from its own bank, so was looking for a simple, flexible solution to accept and process the payments. WorldPay provided them with the Bank Direct solution that enables them to accept payments securely over the internet, from a broad range of payment cards and types including: Visa, MasterCard, American Express, Electron, JCB, Diners; Ireland-specific cards like Laser; UK-specific cards like Switch and Germany-specific payment instruments like Lastschrift

Nolan comments: “Using WorldPay makes our lives, and those of our customers, a lot easier by having a reliable payment solution. Our web site sees up to 2,000 transactions a day; WorldPay processes them all smoothly and securely and we are very pleased with the result.”

The Web Reservations suite of websites including: Hostelworld.com, Hostels.com, Hostelplanet.com and Discounthotels-world.com have met with huge success and now attract over 2 million visitors per month. The company has been recognized within the industry for its achievements, with Hostelworld.com winning ‘Best e-commerce site’ and ‘Best of the Best’ at the ESAT-BT Golden Spider awards 2002.

Related Studies

According to Jenerly Mamanao:

“Computerization program is deemed the best alternative solution to the once stagnant method of manual operation. The process virtually enhances the technical capability of companies and schools in the pursuit of their business venture. To sum up, computerization obtains more credible and systematic way in dealing with records procedural process. The researcher recommends the use of a better and more reliable reservation system, a system that would help much the company in terms of speed and accuracy in processing bus reservations.

It is in this regard that the researcher avails of a better recommendation that will enhance to the great extent the technical output capability of Palazzo de Laoag Hotel. This study hopefully will fill the void and the loopholes that Palazzo de Laoag Ivory Hotel critically needs”.

Data Flow Diagram

Process

Process

Diagram

Diagram

Data flow diagram symbols

Data flow diagram symbols

HIPO

HIPO

Database Design

Data Entry

Data Entry

Data Environment

Data Environment

Data Entry Customer

Data Entry Customer

Data Environment

Data Environment

Entity Relationship

ERD

ERD

Symbols

Symbols

Table Design

Table Fields Field Name Data Type Field Size Primary Key
Reservation First name

Last name Address

Phone no

Email Address

Fax no

Room Type

No of Occupants

Check-in date

Check-in time

Check-out date

Check-out time

Fname

Lname

Add

Phone

Email

FaxNo

Rtype

Occupants

Indate

Intime

Outdate

Outtime

Text

Text

Text

Text

Text

Text

Numeric

Numeric

Date/Time

Date/Time

Date/Time

Date/Time

50

50

70

12

50

12

20

10

10

10

10

10

DEFINING ATTRIBUTES AND DOMAINS

Entity Attribute Domain
Reservation First name

Last name

Address

Phone no

Email Address

Fax no

Room Type

No of Occupants

Check-in date

Check-in time

Check-out date

Check-out time

No of days

A-Z, a-z

A-Z, a-z

0-9, A-Z, a-z

(999)999-99999

0-9, A-Z, a-z

(999)999-99999

A-Z, a-z

0-9

mm-dd-yyyy

mm-dd-yyyy

hh:mm

hh:mm

0-9

Presentation, Analysis And Interpretation Of Data

This chapter presents the data gathered by the researcher from the various sources. These data were analyzed, tabulated and interpreted for purposes of systematic presentation.

 

  1. The status of Reservation system of Palazzo de Laoag Hotel

The present Reservation system of Palazzo de Laoag Hotel is all done manually.

To summarize the current situation of the hotel reservation system, it still follows the traditional way. Customers will still go to the hotel to reserve.

 

  1. The Development of the Online Reservation of Palazzo de Laoag Hotel

B.1. The Process

The power of the computer and the web has amazed the hotel owner so much, so there was no question about the proposed of making the reservation online. In fact, it has been the long cherished dream of the hotel incorporators to see the implementation of fully automated system for the customers and the personnel’s of the hotel is not so distant future.

As a part of the development process it become incumbent upon the researcher to follow the systems development life cycle of project identification, analysis, implementation, revision and maintenance to approach the problem. It was dedicated to start on the basic requirements of the school in the lessons routines to be able to develop workable system to replace the manual system.

B.2 Software Requirements

The following software specifications are required for the system to properly run;

  • Windows XP/2000
  • Macromedia Dreamweaver 2004
  • Microsoft Access 2000
  • IIS(Internet Information Services)

Software requirements were the next concern; what programming language would best apply. The choice was narrowed down to ASP (Active Server Pages) using VBScript was dictated by the familiarity of the researcher with the intricacies of the programming language. In the undergraduate as well graduate level, the encounter with ASP (Active Server Pages) using VBScript was always happy and eventful one.

To keep expenses to the minimum, it was also dedicated that the Microsoft Windows as the operating system for the network set-up to implement the proposed study be adapted.

B.3 Hardware Requirements

The following are the recommended requirements for the system.

  • Pentium IV 2GHz, Intel board Slot A
  • 128 MM SDRAM
  • 4 Hard disk

The hardware requirement was the next concern that had to be tackled. To support the proposed system, the following minimum hardware requirements were identified; one computer unit set-up with the following specifications, processor type Pentium IV 600 megahertz,  Intel Board Slot A plugging all the peripherals devices needed, 128 MB SDRAM of memory of effectively handle multitasking, 8.4 Gb Hard Disk Storage capacity.

This hardware, since they already exist, totally eliminated the major expenses for the project. Foreseen to require the barest of financial support was in the preparation of this study and manpower support in the implementation and maintenance step.

B.4 Design and Development

The programming process was initiated with the writing of codes based on the requirements of client architecture. The standard programming practices of data validation and error trapping were performed throughout to ensure that each phase was running smoothly.

Design of reports outputs was patterned after the reportorial requirements of the hotel.

As a final step, compilation of the program was done to create an executable file that can be used even in the absence do Visual Basic and can be installed or copied to another computer using the Visual Studio. User’s manual was

written as a matter of documentation as user\s reference that contained the programmer’s instructions and explanation on the functions of the system.

Testing and Implementation 

Presentation of the proposed system for a trial run and demonstration among system users was performed. This way necessary to draw comments from the users, suggestions when appropriate, and recommendations that may help improve the system.

The systems were finalized taking into consideration the feedback of the users. The user’s manual was written to incorporate the changes that were adopted as a result of the trial run and demonstration.

  1. Alpha Testing Results

Alpha testing involves the use of test data and not actual data. Simulated names, dates, costs, and data closely resembling what is intended to be processed are used as test data fed into the system. The system is tested if computations performed are correct, if the system is able to handle data and transform it to relevant information in the form of reports needed by the

organization. Output reports are analyzed if they are true representation of the data that were used. Alpha testing to sufficiently establish the acceptability of the system tested should be made to handle of sizable amount of data not necessarily approximating the size of data intended to be handled. The amount of data is such that the system is sufficiently tested for consistency of its output.

Results of the Alpha Testing done on the Proposed System are the following:

  1. Logging in using the system is embedded for security measures for unauthorized users.
  2. The system automatically generates.
  3. Desired results in the reservation reports are consistent and correct.
  4. Error trapping is the features of the proposed system.
  5. Data is secured from corruption by users and is automatically backed-up during routine operations to ensure data recovery.
  1. Beta Testing Results

Initials Beta testing used data from the Hotel Manager. Due to time constraints, one week testing was allotted for Initial Beta testing.

Table 4.1 shows the tabulation of results of the evaluation by respondents on the proposed system.

Table 4.1

Weighted Mean Distribution off Respondent’s Evaluation on the proposed system

  1. Efficiency of the Website
Mean Verbal Interpretation
1. The pages can be easily loaded or accessed.
2. The navigation icons/page controls are easy to follow.
3. The site allows interactive sharing of information.
4. The transactions are correctly and accurately processed
5. The database of the system is reliable.
  1. Quality of Information
Mean Verbal Interpretation
1. The information available on the pages are updated.
2.  The information are pertinent to your need.
3.  The information are presented with sufficient depth.
4.  The information are adequate and readily verifiable.
5. There are no typographical and grammatical errors found in the website.
  1. Layouts and Graphics Appropriateness
Mean Verbal Interpretation
1. The site was designed with good graphic design principles.
2. The graphics or pictures are clearly labeled and identified.
3. The font type and font sizes of the texts are appropriate and readable.
  1. Security and Maintenance
Mean Verbal Interpretation
1. The pages are secured from tampering/ hacking by users or visitors.
2. The page/s allows periodic update.

On the proposed systems’ capability to support Making and Taking Reservation, maintaining an organize and portable database, the interface of the system is user friendly, it allows the customer to cancel his/ her reservation within a reasonable time, the system automatically generates the reservation form and stores it in the database, there is sufficient field for directions, the system allows the front desk personnel to update, add, edit or delete items in the existing reservation, there is a help future that will guide a neophyte user on the use of the system, the system allows the personnel to generate reports for the reservation, features and design give the customer and personnel convenience to use the system over ball pen paper reservation type. Each category received a weighted mean of greater than 4, which mean the respondents strongly, agree that in all categories the expectations ore met and fully realized. Furthermore, the overall weighted mean of 4.33 corresponding to a verbal interpretation of “Very Strongly Agree” indicates that the proposed system has made used of function.

  1. The Efficiency of the proposed Online Reservation System

Contrasted to the previous manual system, the proposed Online Reservation system has overall relieved personnel especially for the personnel from the tedious work of Making and updating reservation and repeating common tasks of data entry every reservation process.

Securing data from various factors that threaten data integrity involves standard programming routine that are build into proposed systems design. The proposed system has successfully built security around data using these basic principles in programming routine.

The ultimate test of system relevance is its usefulness and functionality, its ability to deliver according to the defined expectations from the systems that they intend to replace.

The proposed system has shown superiority in the aspects of usefulness and functionality for the following reasons: the design has been tailored-made according to the identified needs of the personnel; among its standard features are used of access keys and shortcuts that endow the system with an ease of handling and user-friendliness; structured rather than hard-coded programming was used; the system boast of error-free that can be relief to effectively handle and process data and generate reports for the customers and personnel’s.

The presentation of the proposed system is commendable. The graphical user interface is both appealing and friendly. There is a unity and consistency in the grouping of functions and objects. A screen design simulates windows application and overall is pleasant and shows the virtue of taste in special effects.

Benefiting the staff and personnel of Palazzo de Laoag Hotel as a whole, it also stands to benefits the customers who take reservations. Reservation was simplified and personnel and customer do not have to work hard for making the reservation. Repetitive routines are eliminated and customers do not have to go to the hotel. There is no question as to the acceptability of the proposed system. For one, Palazzo de Laoag Hotel has long depended on the manual system in its reservation routines. This system offers superior alternative that makes for ease, efficiency as well accuracy.

Summary Of Findings, Conclusion And Recommendation

This chapter presents the summary of all the data gathered by the researcher. It also includes the conclusion that could be ascertained. Finally, some recommendation was formulated for further improvement of the study.

Summary of Findings

Based on the data presented and analyzed in Chapter 4, the following findings were obtained.

  1. That the proposed system provides a systematic handling and generation of reports.
  2. The proposed system processes quicker than the present system.
  3. That the proposed system procedures computer generated reports.

Conclusion

Based on the result of the study, the researcher concludes that the proposed system is faster in processing the reservation.

Recommendation

The researcher therefore recommends that the present system should be online for faster processing of data and for generation of accurate reports.

 

 

Share This Post!