Study Of A Hotel Reservation System Computer Science Essay

Published:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

This project is about build an Hotel system reservation related to information technology in order to help the employee and provide the assistance they needs for the customer as soon as possible. This project as final project includes four chapters. So the introduction and the background of our project will help the reader to get the idea of this project and understand more when we identifying the aim, objectives and the problem definition. While it come some scope and the constraints of this project. The review of literature is one of the ways that provide the ideas and information around the subject area. So the internet online become important to get more information about my final project and wider used in our life also it carry out a huge number of activities. From our aim of this project that developing Hotel system reservation, there are some tools of web development and project methodology that we discussed in chapter two, so all these tools can help to used and develop our system . In addition the chosen of two cases study of website related to Hotel system reservation it helps us to know the features and the elements of these system. One of the fundamental ways to find and gather the information related to our project (Hotel system reservation),so there are different types of the research methods that help to gather all information we needed and then analysis it to carry out the result. From all these types of research methods we discussed in chapter three and making the questionnaire to collect the information about hotel and analysis it to get the result. However there are some of functional requirement and non functional requirement needed to our Hotel system reservation to be successful and good design of the system. The plan is one of the most important step for this project, so it help to execution of project and know how many time spend in starting time and ending of this project. While there is tool can show the all activities and tasks in this project as namely "Gantt chart". In addition there are some project elements and resources need for this project we discussed.

To understand the concept of Hotel reservation .

To design a computer based information system.

To semi-automatic hotel reservation process.

To design and create a more efficient hotel reservation system.

Goals & Objectives

The goals and objectives which my project has are the following:

To learn how I can develop new software system.

To learn how I can develop new website with the control panel .

To work hard and learn and to take responsibility to complete this project on time.

To convert manual way to technology way.

To learn more about Microsoft Access and Visual Basic programs also other program which I use it (Adobe Dreamweaver CS4, Adobe Photoshop CS4 , Adobe After Effects CS4, Adobe Flash CS3 Professional, SmartDraw 2010 and Microsoft Office .

To save time for customer.

To share and get knowledge from internet also books.

To improve my experience through collect information using different facilities and different methods.

To improve skills and knowledge.

To make the Hotel system easy for the employee .

To establish database that can assist with more securities .

To encourage Hotel trainees to give the employee the idea about software.

To help employee to identify their needs of customer.

To reduce paper work .

To monitor can show how many room are reserves in the hotel.

To ensure more secured for the data.

The system can give the employee the better interface to select the option easy.

To show for the guest in Oman or forgine what we have in our website and also the location for the hotel .

To have website with all index page , about hotel , hotel gallery , guestbook , contact us , our offer and news .

Introduction

Hotel Reservation is one of the common business types in whole the world. The company

In ALsharqiya Sands Hotel what have been build in 1991 years old near Ibra hospital that can offer The best service for the customers. This Hotel open every day be using the many worker there Omani and India worker in shift time 24 hours to maintaining all services for the all region or other people . The customer when he/her needs to reserve room from the hotel. they must give the full information what include Customer id , customer……. with all documentation need to include it to complete the booking for the room what customer needs to reservation ,such as will be for the customer will be allowed for him/her to order the food or the drink or need any help from the reception will by using the phone from room directly . There are many services allowed for the customer to use like the swimming pool and the internet form the service for the hotel . also the hotel having the many sections for the room will be depend for the customer what type will needs to reserve the room with include all the other services if the customer needs for that .Finally the hotel care about the customer with giving the customer him respect and …… . As of the success in the business of the hotel reservation adopted a computer base system so as to accommodate more client and provide a convenient and efficient transaction to every one, hence business will become more competitive in nature. It was also noted that those who use a computer base system become more productive and organize records of client efficiently.

For this reason, I decide to propose and design a computer based for Hotel Reservation system to at least change the current manual process to technical system.

Problem Definition

The main problem in this Hotel is a manual system and it is only use paper based with Hotel operation so this problem make the work slow and it is difficult for the Employee member to work easily and faster. Also when the staffs using manual system sometimes occurs several errors such as error in record the number of the Reservation room in Hotel , error when they record the name or the address of the customer and they sometimes make mistake in record and also the calculation. So all these can affect for the Hotel and the customer too .In addition another problem for the customer is they sometimes waste their time by waiting for along time until they are serving.

Data integrity Too many paperwork lead to inaccuracy of filing record hence if a second timer or third timer customer need to reservation of Room , he will repeat the same process of filing up information redundancy in customer record lead to voluminous file of paper work.

Data security Security of confidant information is necessary to avoid an authorize user to gain access to clients record. Hence security must be given a priority to any system.

Time-consuming Time is a very important aspect of every potential client. If he\she can process everything in less time than I can say that I have efficient system with the website about the hotel and general think.

Need for applications:

Advantages:

Use an easy system for Hotel Reservation .

Save the employee time in processing customer information.

Save all records in database system. These records keeping will be efficient.

Securities and copy right for the hotel .

Benefits of the company:

Storing of customer record will become organize.

Efficient customer-renter relationship.

Data integrity will be preserved.

Secured record keeping.

Smooth operation on transactions.

Proposed System:

I will create a new computerized Hotel Reservation system for the ( Ibra Hotel ). In this project I used some application .first application what I will use is Microsoft Visual Studio 6.0 software also Microsoft Office Access 2003 to create the database and Adobe Photoshop CS4 to make the background and all icon make it very attractive to use it on the program what I use it to make the Hotel Reservation system , there is also I will use something new application that I didn't study before for making the higher technique use for the design 3D showing . .

There are three program I will use it to make the website and also the introduction created with higher effective . Firstly I will use Adobe Dreamweaver CS4 , also SQL . Reading and the PHP reader to read this language as showing what I created by using adobe Dreamweaver CS4 , The proposed for this program to show all the services and all thing about hotel such as , Home page , about hotel , services , guest book , photo gallery and contact us .

In this project I used application such as: Visual Basic 6.0 (used as the main application software used for designing and developing the software. Like Project, Forms and Reports are designed and coding using this application) and Microsoft Access (used as the backbone of the software application where in the database, tables and relationships were conceptualized). I wish that Visual Basic will be very best program for maintain the system and I have to learn about it more than I have knologment to develop me study as I can by searching for new information form the book ,also using internet to get coding what will help me more . I will use database to create tables for any requirement what I needed for the hotel Reservation system and link it to gother to be all linked to reduce the redundancy information and to be very exactly or specific information needs for the hotel .

Scope of the Project:

The project is will be help the employees for doing the work very fast . The project study will use primarily the Microsoft Access to making the database also with connection with the second program Microsoft Visual Basic 6.0 what I will make the system and other programs used are Adobe Dream weaver CS4 ,Photoshop CS, Also the Adobe Flash CS3 Professional to make the introduction about the project and also will be website for showing information about the hotel with the gallery and about hotel . There are java script also HTML will be include it to develop the for supporting unit for the program and for the website about the system and the now offer about the hotel ,also Visual Basic 6.0 code will be used to develop the system and make all option working as well .

Building on the project, I will faced a lot of difficulties during working in the project. At first time, it was difficult for me to create the system with database and also website to give the information for the guest , when I start the project I don't have enough perspectives about the hotel acutely .In other hand I create many and many image in me head to show the idea what I needs to be created by me . To show the all project be higher knwegment with using the technology .The other difficulties are the no enght resource for the hotel form the department for the hotel , but I try the best what I can to show analysis for this hotel and creating the my own resource be using the books and also the internet . At last what I tried that be not engh for me to get what I need less then what I get about all the project so I go to search for the teachers how have skills to help me in this project and to give me more idea such as more understand for the project , overcome all of these problems in suitable time and finish me project to our best.

Hardware / Software Configrative:

The needs for doing the project as wall with out any problem and the hardware mast include it to be handle the all project so I use in my beginning Microsoft Office Access 2003 to make the systematically database be using with check all what I need to create in this database for saving the all information for the hotel , The second thing I use Microsoft Visual Basic 6.0 to creating the hotel reservation system with making the interface view and the process for the system all included by using this program called Visual Basic , the tired thing I will use Adobe Dreamweaver CS4 to make website including the information for the hotel with design template be Adobe Photoshop CS successfully for the user and can contact us throth the website . What I called before what program what I use for , and the computer what I need must be an (compatible) computer with a higher processor all the requirement must be very good to handle those program with out problem.

So To get reasonable performance , I recommend with at least 4GB Ram . With more engh hard desk at least 160 GB, the process will be 2.2 Core 2 Duo to be able to run more applications simultaneously, and overall performance will be increased. A fast video card is also recommended to display pictures and graphs.

Hardware Interface:

The following are the recommended requirements for the system.

2.2 Core 2 Duo GHz.

At list 4GB RAM.

160 GB of Hard disk..

32X CD-DVD-RW-Drive.

External Hard disk 80GB - Backup information & system.

Software Interface:

Microsoft Office :-

Microsoft Office Word 2007

Microsoft Office Access 2003

Microsoft Office Project 2003

Microsoft Office PowerPoint 2003

Microsoft Visual Studio 6.0

Adobe Dreamweaver CS4

Adobe After Effects CS4

Adobe Flash CS3 Professional

Adobe Photoshop CS4

Nero Express

It must be purchased separately .firstly I installed Windows XP services pack 3,After that I started install all the program what I purchased .

Methodology and Analysis Design

Waterfall model :

The Waterfall model

Database Schema

Table name: Customer

Customer with the following fields:

CustomerID

Text

Size

Description

TitleOfSalutation

Text

20

The car kind name

FirstName

Text

20

The product of company name

LastName

Text

8

The year that that car made in

SecondName

Text

8

The number of car plate

Gender

Text

1

The colour of the car

Birthdate

Date/Time

Date/Time

The daily rent fee

CustomerAddress

Text

20

ContactNo

Number

10

EmailAddress

Text

20

IDDocumentType

Text

Selection

IDDocumentNo

Text

20

DateOfExpiry

Date/Time

Date/Time

CountryOfOrigin

Text

20

Table name: Employee_

Employee with the following fields:

Fields Name

Data Type

Size

Description

FirstName

Text

20

The product of company name

SecondName

Text

8

The number of car plate

LastName

Text

8

The year that that car made in

Gender

Text

1

The colour of the car

Birthdate

Date/Time

Date/Time

The daily rent fee

Address

Text

20

ContactNo

Number

10

EmailAddress

Text

20

UserID

Text

Selection

PWord

Text

EmployeePhoto

Text

Table name: Payments

Payments with the following fields:

Fields Name

Data Type

Size

Description

BillNo

Text

50

ReservationID

Text

100

BillDate

Date/Time

30

BillTime

Date/Time

10

CheckOutDate

Date/Time

15

CheckOutTime

Date/Time

7

EmployeeID

Text

10

CreditCardType

Text

6

CreditCardNum

Number

8

DateOfExpiry

Date/Time

8

Table name: Miscellaneous

Miscellaneous with the following fields:

Fields Name

Data Type

Size

Description

BillNo

Text

20

Particulars

Text

20

MiscDate

Text

20

Price

Text

20

Remarks

Text

20

Table name: Reservation

Reservation with the following fields:

Fields Name

Data Type

Size

Description

ReservationID

Text

50

ReservationDate

Date/Time

100

ReservationTime

Date/Time

30

RoomID

Text

10

CustomerID

Text

15

EmployeeID

Text

7

CheckInDate

Date/Time

10

CheckInTime

Date/Time

6

ResStatus

text

8

Table name: Payments

Table name: Rooms

Rooms with the following fields:

Fields Name

Data Type

Size

Description

RoomID

Text

50

RoomType

Text

100

MaximumGuest

Number

30

Smoking

Yes/No

10

Description

Text

15

FloorNumber

Text

7

PhoneCode

Text

10

PricePerHour

Text

6

MinimumHoursStay

Text

8

Feasibility Study

The purpose of our project is:

To convert manual system to technology system.

To save the time of the customer.

Storing of customer record will become organize.

Secured record keeping.

Operationally

The purpose of developing the system of car rental is to convert the annual system to computer

based system. This operation makes the system easy for customer and employee. It also saves the

time for both of them. By this way the storing of customer record will become organize and keeping the

records to be secured.

Technically

The employee does not need to take training to use the system. Because the employee is already

computer literate. The employee just needs to know how to enter the data in the system.

Economically

Since the company already have this system, they can save in the procurement of office supplies

hence there will save in the operational cost of the company.

Figure 1:

Flowchart of manual process

ER_Diagram

Customer

Address

E-mail address

nationality

Type of license

ID-card

gender

Name

Address

House -NO

Work-NO

Phone-NO

Car

Plate-NO

Manufacture

Model

Color

Car type

Rent fee

Customer History

Employee-ID

Employee name

Date in

Date out

Total fee

Deposit-NO

Plate -NO

Name

Car type

ID-card

Employee

Log out

Log in

password

Employee name

Employee -ID

Figure 7 :

Data Link

Conclusion

In this report, many problems have been taken and discussed. We have given a simple view of our project like that what is the idea of it and the steps that we followed until we finished the project.

Car Rental Monitoring System is one of the necessary thing in business. It is useful for renting agency. This system is important to organize Cars, Customers, Employees and Customer_History records. From this project we learn many things about car rental and how to use Visual Basic.

Database Design

Screen Design

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.