Study OF AN Hotel Booking System Computer Science Essay

This project is about build an Hotel system reservation related to information technology in order to help the staff and offer the assistance they needs for the client as soon as possible. This job as final project includes four chapters. Therefore the introduction and the backdrop of our task can help the audience to get the thought of this job and understand more when we identifying desire to, objectives and the situation definition. While it come some opportunity and the constraints of this project. The overview of literature is one of the ways that provide the ideas and information around the subject area. Therefore the internet online become important to obtain additional information about my final job and wider used in our life also it carry out a huge number of activities. From our aim of this project that growing Hotel system reservation, there are a few tools of web development and project methodology that people discussed in chapter two, so each one of these tools can help used and develop our bodies. In addition the chosen of two instances research of website related to Hotel system reservation it helps us to learn the features and the elements of these system. Among the fundamental ways to find and gather the information related to your project (Hotel system booking), so there are different kinds of the study methods that help to accumulate all information we needed and then analysis it to handle the result. From all these types of research methods we discussed in chapter three and making the questionnaire to accumulate the information about hotel and examination it to get the result. However there are some of functional necessity and non practical requirement needed to our Hotel system booking to reach your goals and good design of the machine. The program is one of the most important step for this project, so that it help execution of project and know how many time spend in starting time and concluding of this job. While there is tool can show the all activities and jobs in this job as particularly "Gantt chart". You can also get some job elements and resources need for this project we mentioned.

To understand the concept of Hotel reservation.

To design a computer based mostly information system.

To semi-automatic hotel booking process.

To design and create a far more efficient hotel booking system.

Goals & Objectives

The goals and goals which my job has are the following:

To understand how I could develop new software system.

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

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

To convert manual way to technology way.

To find out more about Microsoft Access and Aesthetic Basic programs also other program that i put it to use (Adobe Dreamweaver CS4, Adobe Photoshop CS4, Adobe CONSEQUENCES CS4, Adobe Flash CS3 Professional, SmartDraw 2010 and Microsoft Office.

To save time for customer.

To show and get knowledge from internet also catalogs.

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

To improve skills and knowledge.

To make the Hotel system possible for the staff.

To establish repository that can assist with an increase of securities.

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

To help employee to identify their needs of customer.

To reduce newspaper work.

To keep an eye on can show just how many room are reserves in the hotel.

To ensure more secured for the data.

The system can provide the worker the better software to select the option easy.

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

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

Introduction

Hotel Booking is one of the common business types entirely the world. The company

In ALsharqiya Sands Hotel what have been build in 1991 years old near Ibra hospital that may offer The best service for the customers. This Hotel open up every day be using the countless staff member there Omani and India staff member in shift time 24 hours to maintaining all services for the all region or other people. The client when he/her needs to reserve room from the hotel. they need to supply the full information what include Customer id, customer. with all documents need to include it to complete the scheduling for the room what customer needs to reservation, such as will be for the customer will be allowed for him/her to order the meals or the drink or need any help from the reception will utilizing the mobile phone from room directly. There are lots of services allowed for the client to make use of like the pool and the internet form the service for the hotel. also the hotel getting the many areas for the room will be depend for the customer what type will needs to reserve the area with include all the other services if the customer needs with the. Finally the hotel care about the client with giving the client him respect and. By the success available of the hotel booking adopted a pc base system to be able to accommodate more customer and provide a convenient and useful transaction to every one, hence business will become more competitive in aspect. It had been also noted that those who use a computer base system become more productive and organize information of client effectively.

For this reason, I decide to propose and design a pc founded for Hotel Booking system to at least change the existing manual process to technological system.

Problem Definition

The problem in this Hotel is a manual system and it is only use paper founded with Hotel operation so this problem make the task slow which is problematic for the Staff member to work easily and faster. Also when the staffs using manual system sometimes occurs several problems such as problem in record the amount of the Reservation room in Hotel, error when they record the name or the address of the customer plus they sometimes make miscalculation in record and also the calculation. So all these make a difference for the Hotel and the customer too. Furthermore another problem for the customer is they sometimes squander their time by waiting for along time until they are really serving.

Data integrity Way too many paperwork business lead to inaccuracy of filing record hence if another timer or third timer customer need to booking of Room, he will repeat the same procedure for processing up information redundancy in customer record lead to voluminous record of paper work.

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

Time-consuming Time is an essential aspect of every potential client. If he\she can process everything in less time than I could say that I've productive system with the website about the hotel and basic think.

Need for applications:

Advantages:

Use an easy system for Hotel Reservation.

Save the worker time in digesting customer information.

Save all records in database system. These details keeping will be useful.

Securities and backup befitting the hotel.

Benefits of the company:

Storing of customer record can be organize.

Efficient customer-renter marriage.

Data integrity will be conserved.

Secured record keeping.

Smooth operation on orders.

Proposed System:

I will create a fresh computerized Hotel Reservation system for the ( Ibra Hotel ). On this job I used some request. first software what I am going to use is Microsoft Visual Studio 6. 0 software also Microsoft Office Gain access to 2003 to set-up the database and Adobe Photoshop CS4 to make the record and all icon make it very attractive to put it to use on this program what I utilize it to help make the Hotel Reservation system, addititionally there is I will use something new software that we didn't research before for making the higher strategy use for the look 3D showing. .

There are three program I will use it to help make the website as well as the introduction created with higher effective. Firstly I will use Adobe Dreamweaver CS4, also SQL. Reading and the PHP reader to learn this dialect as demonstrating what I created by using adobe Dreamweaver CS4, The proposed because of this program showing all the services and everything thing about hotel such as, Home page, about hotel, services, guest book, photography gallery and e mail us.

In this job I used software such as: Visual Basic 6. 0 (used as the main application software used for making and developing the program. Like Project, Varieties and Reports are designed and coding making use of this software) and Microsoft Access (used as the backbone of the program program where in the database, tables and romantic relationships were conceptualized). I wish that Visual Basic will be absolute best program for keep up with the system and I must find out about it more than I've knologment to develop me review as I could by searching for new information form the reserve, also using internet to get coding exactly what will help me more. I will use database to build tables for any necessity what I necessary for the hotel Booking system and link it to gother to be all linked to reduce the redundancy information and also to be very exactly or specific information needs for the hotel.

Scope of the Job:

The task is will be help the employees for doing the work extremely fast. The project analysis will use mostly the Microsoft Access to making the repository also with connection with the next program Microsoft Visual Basic 6. 0 what I will make the machine and other programs used are Adobe Desire weaver CS4, Photoshop CS, Also the Adobe Display CS3 Professional to make the release about the project and also will be website for showing information about the hotel with the gallery and about hotel. You can find java script also HTML will be include it to build up the for assisting unit for the program and for the web site about the system and the now offer about the hotel, also Visible Basic 6. 0 code will be used to develop the system and make all option working as well.

Building on the job, I will experienced a whole lot of complications during employed in the project. Initially time, it was problematic for me to produce the machine with databases and also website to give the information for the guest, while i start the project I don't have enough perspectives about the hotel acutely. In other side I create many and many image in me check out show the theory what I must be created by me. To show the all task be higher knwegment with using the technology. The other issues will be the no enght resource for the hotel form the team for the hotel, but I try the best what I can to show evaluation for this hotel and creating the my own resource be using the literature as well as the internet. Finally what I tried that be not engh for me personally to get what I need less then what I get about all the job therefore i go to find the professors how have skills to help me in this job and to give me more idea such as more understand for the project, overcome many of these problems in suitable time and finish me project to your best.

Hardware / Software Configrative:

The needs for doing the project as wall with out any problem and the hardware mast include it to be cope with the all job so I use in my start Microsoft Office Gain access to 2003 to make the systematically database be using with check all what I need to create in this repository for conserving the all information for the hotel, The next thing I take advantage of Microsoft Visual Basic 6. 0 to creating the hotel booking system with making the interface view and the process for the machine all included employing this program called Visible Basic, the exhausted thing I'll 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 e mail us throth the web site. What I called before what program what I take advantage of for, and the computer what I want must be an (suitable) computer with a higher processor all the necessity must be very good to take care of those program devoid of problem.

So To get fair performance, I recommend with at least 4GB Ram memory. 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 efficiency will be increased. A fast video cards is also advised to show pictures and graphs.

Hardware User interface:

The following are the recommended requirements for the machine.

2. 2 Key 2 Duo GHz.

At list 4GB RAM.

160 GB of Hard disk drive. .

32X CD-DVD-RW-Drive.

External Hard disk drive 80GB - Back-up information & system.

Software Interface:

Microsoft Office :-

Microsoft Office Word 2007

Microsoft Office Gain access to 2003

Microsoft Office Task 2003

Microsoft Office PowerPoint 2003

Microsoft Visual Studio room 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 load up 3, From then on I started install all the program what I purchased.

Methodology and Research Design

Waterfall model :

The Waterfall model

Database Schema

Table name: Customer

Customer with the next 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 volume of car plate

Gender

Text

1

The colour of the car

Birthdate

Date/Time

Date/Time

The daily lease 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: Worker_

Employee with the following fields:

Fields Name

Data Type

Size

Description

FirstName

Text

20

The product of company name

SecondName

Text

8

The amount of car plate

LastName

Text

8

The year that that car made in

Gender

Text

1

The color 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 reason for our project is:

To convert manual system to technology system.

To save enough time of the customer.

Storing of customer record can be organize.

Secured record keeping.

Operationally

The reason for developing the system of car lease is to convert the gross annual system to computer

based system. This procedure makes the system possible for customer and employee. It also will save you the

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

records to be anchored.

Technically

The employee doesn't need to use training to utilize the system. Because the worker is already

computer literate. The employee just must learn how to enter the info in the system.

Economically

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

hence there helps you to save in the functional 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've given a simple view of your project like that what is the thought of it and the steps that people followed until we completed the task.

Car Hire Monitoring System is one of the required thing in business. It is useful for booking agency. This system is important to arrange Automobiles, Customers, Employees and Customer_Record records. Out of this job we learn many things about car rentals as well as how to use Aesthetic Basic.

Database Design

Screen Design

Also We Can Offer!

Other services that we offer

If you don’t see the necessary subject, paper type, or topic in our list of available services and examples, don’t worry! We have a number of other academic disciplines to suit the needs of anyone who visits this website looking for help.

How to ...

We made your life easier with putting together a big number of articles and guidelines on how to plan and write different types of assignments (Essay, Research Paper, Dissertation etc)