Database Normalization and Hotel Reservation Website

Only available on StudyMode
  • Download(s) : 108
  • Published : January 29, 2013
Open Document
Text Preview
GRAND ASTORIA HOTEL RESERVATION WEBSITE

A Project
Presented to
the Faculty of STI College-Zamboanga

In Partial Fulfillment
of the Requirements for the Degree of
Bachelor of Science in Information Technology

by
Calisang, Ellis Marc D.
Caramonte, Edcel B.
Lim, Jason Justin O.

Abdu-Shakoor L. Ibrahim
Project Adviser

October 2012

ADVISER’S RECOMMENDATION SHEET

This Project entitled

GRAND ASTORIA HOTEL RESERVATION WEBSITE

By:
Calisang, Ellis Marc D.
Caramonte, Edcel B.
Lim, Jason Justin O.

Submitted in partial fulfillment of the requirements of the
Bachelor of Science in Information Technology
Has been examined and is hereby recommended
For acceptance and approval

______________________
Abdu-Shakoor L. Ibrahim
Project Adviser

October 2012

PANEL’S APPROVAL SHEET

This Project entitled

GRAND ASTORIA HOTEL RESERVATION WEBSITE

Developed by:
Calisang, Ellis Marc D.
Caramonte, Edcel B.
Lim, Jason Justin O.

After having been presented is hereby approved
By the following members of the panel

____________________________________________
Mr. Aldimin A. KalliMr. Whesley G. Timpangco
Panelist Panelist

___________________________
Mr. Abdu-Shakoor L. Ibrahim
Lead Panelist

October 2012

CHAPTER 1

1 Introduction

Technology has transformed many aspects of life in this generation, including the way many of us make reservations. Traditional ways of reserving through telephones, cellular phones and walk-in can’t cope up the with other customers who have a busy schedule that are in need of faster way to reserve and pay. In this matter, it is in higher advantage to develop a fully functional website which provides online reservation. The benefits of such system are as follows: it can gain international exposure and also be an effective online brochure that is available to everyone in the world; it can also expand target market, leading to increased occupancy levels. Increase profits, stay competitive, control tour marketing.

1. Statement of the Problem

The Grand Astoria hotel is suffering with slow procedure on indirect reservations with insufficient data given by the guest when reserving through phone calls and emails. Also, it has no assurance that the guest will surely pay through credit. They have no views of information of different rooms and facilities found in the establishment.

2. Current State of the Technology

The emerging need of high quality based technology is a must in different industries including the tourist attraction spot such as hotels. In the case of Grand Astoria Hotel, the expansion of customer reach is low because they are not provided with a website that connects to other potential customers internationally. The current state of their technology when reserving are as follows: 1. ask details check in and check out time; 2. information about the guest; 3. choose what kind of room; 4. check if it is available; 5. if the room is unavailable, check for other rooms that is available; 6. reserve and confirm the reservation to occupy.

3. General Problem

The main problem of this study is the inaccurate reservation of the customer.

1. Specific Problem

1. Low in security

2. Less data integrity

3. Time monitoring

4. Difficulty in searching and retrieving files

5. Possible loss of records and retrieving files

6. Difficulty in finding the availability of rooms and facilities

7. Lack of Generating Reports

4. General Objectives

The study aims to solve the problem that the hotel encountering...
tracking img