PUNE VIDYARTHI GRIHA’s COLLEGE of

ENGINEERING & S.S.DHAMANKAR INSTITUTE of

MANAGEMENT NASHIK

Department Of Computer Engineering

A project report on

“Tourism management system”

By

1) Rutuja Sunil khairnar

Subject – DATABASE MANAGEMENT SYSTEM(2019 Pattern)

Guide
Prof.Ifat Shaikh.
PUNE VIDYARTHI GRIHA’s
COLLEGE of ENGINEERING & S.S.DHAMANKAR INSTITUTE of
MANAGEMENT NASHIK

CERTIFICATE

This is to certify that student

1) Rutuja sunil khairnar

of Third year Computer Department has successfully completed her/his

project on “Tourism Management System” in the subject Database
Management System during the A.Y.2022-23

Project Guide HOD

Prof.Ifat Shaikh Prof.J.Y.Kapadanis

ACKNOWLEDGE

I sincerely express a deep gratitude towards our guide

Prof. I. Shaikh for his/her continuous guidance and efforts for completion of
this project. I am also grateful to Prof J.Y.Kapadnis,
Hea of Computer Department of our institute for his motivation and support. I
am thankful to in charge of Database Management System. Prof. I. Shaikh for
his encouragement
I am very thankful to my team members for their contribution in completion of
this project successfully.
ABSTRACT

Our project traveland travel management system includes registration

of customer, storing their details into the system, and also booking
their tour. Our websites has the facility to give a unique id for every
customers and stores the details of every customers and save details
automatically. User can search availability of a tour and the details of
spot using there id. The tours and travel management system can be
entered using a username and password. It is accessible by sign in
page. Only they can add data into the database. The data can be
retrieved easily. The interface is very user-friendly. The data are well
protected for personal use and makes the data processing very fast. .
INDEX

CHAPTER :- 1

i. INTRODUCTION
ii. EXISTING SYSTEM
iii. PROPOSED SYSTEM

CHAPTER :- 2

LITERATURE REVIEW

i. METHODOLOGY

ii. INPUT DESIGN and OUTPUT DESIGN

iii. PROJECT OUTCOMES
iv. CONCLUSION
v. ADVANTAGES

CHAPTER :- 3
i. ANALYSIS AND DESIGN
ii. OVERVIEW OF THE EXISTING SYSTEM
iii. SYSTEM DESIGN
iv. OUTPUT DESIGN
v. SYSTEM SPECIFICATION ANALYSIS

CHAPTER :- 4

i. HARDWARE REQUIREMENTS
ii. CHOICE PROGRAMMING LANGUAGE
CHAPTER :-5

ANALYSIS/IMPLEMENTATION/ARCHITECTURE
i. EXPECTED OUTCOME OF THE PROJECT
ii. RESULT

CHAPTER :-1
INTRODUCTION TO TOURS AND TRAVEL MANAGEMENT
SYSTEM

I.INTRODUCTION
Travel and tourism management systems are used to book tours from
anywhere in the world. The admin can add packages to the website from travel
agents and hotels, and the users can sign in and book each project. The system
allows the user to access all the details such as location, events, etc., and the
main purpose is to help tourism companies manage customer and hotels. It can
also be used for both professional and business trips.

II. EXISTING SYSTEM

The existing system has many difficulties and drawbacks due to its manual
maintenance. These include increased transaction, increased source document,
and incorrect admin/user entry. These drawbacks make it difficult for travellers
to achieve their needs in time and accurate results.

III. PROPOSED SYSTEM

Provides up to date information

• Friendly Environment by providing warning messages

• travellers details can be provided The proposed system is designed

to be more efficient than the manual system.

• It invokes all base tasks that are now carried out manually, such as
the forms transactions and reports which is added advantage.

Thousands of records can searched and displayed without taking any significant
time Advantages of the Proposed System:
• Gives accurate information
• Simplifies the manual work
• It minimizes the documentation
• booking confirmation notification
CHAPTER 2

LITERATURE REVIEW
Data analysis is the process of coding, organizing, filtering, categorizing,
relating and related abstract concepts. Software allows for comparisons among
different concepts simultaneously, which simplifies qualitative data analysis and
improves the accuracy of research findings. Critical strategies such as method
triangulation, conformability audit and member checks are applied to ensure
trustworthiness of research findings. Information search (traveller’s
perspectives) and market segmentation by information/booking channel are used
to investigate the reasons why travellers make use of different sources of
information. Grand Tour, education, higher education, travel & tourism are the
main topics for learn & discuss about it. Mobile devices are becoming more
intelligent, providing information in mobile itself. Tour management systems
based on the internet provide self-guidance for tourists in mobile phones.

METHODOLOGY
1. Admin authentication
This module is mainly based on admin. System will check the admin user name
and password for authentication. After the verification for authorization the
admin can be able to precede the process. All works are done under his control.

2. User Registration

The module allows users to register themselves by adding data such as name,
password, email id and further details. Package creation allows admins to create
packages with type, price, details and place details, which will be shown on user
homepage.

4. Package booking

In this module maintain the booking of travel packages by the user by selecting
a various package with date and certain comments.

5. Booking confirmation/manage

Booking confirmation is the process of confirming the booked packages by the

admin that is booked by the user with date and comment. Also, admin can
manage the booking by cancelling.

6. Issue ticket

Tickets can be issued for the user in the issue ticket page in the homepage of
user the certain booked packages only can be issued. Tickets can be issued for
the user in the issue ticket page in the homepage of user the certain booked
packages only can be issued.

7. INPUT DESIGN and OUTPUT DESIGN

Input Design converts user-oriented inputs to computer-based formats,

controlling error data entered by the data operator. It is menu-driven and
interactive, helping the user understand the range of alternatives available and
prevents them from making an invalid selection. All entry screens are interactive
in nature, taking into account the constraints of the end-user.

Some other features included are:

➢ The form title clearly states the purpose of the form

➢ Adequate space is given for data entry Data Validation is done for
eliminating duplicate entries
➢ Usefulness determining the various outputs to be printed to the system
user.
➢ Differentiating between the outputs to be displayed and those to be
printed.
➢ The format for the presentation of the output.

Outputs are the most important and direct source of information to the customer
and management. Intelligent output design will improve the system's
relationship with the user and help in decision making. Outputs are used to
make permanent hard copies of the results for later consultation. The output
design was based on factors such as compatibility with existing manual reports.
Hard copies are preferred since they can be used by the controller section for
future reference and for maintaining the record.

PROJECT OUTCOMES
• This system will provide communication facilities among customers
and agents through internet.
• Providing facilities to modify and delete tourist’s data as well as
client’s data. •To provide information about the inbound and
outbound tour packages.
• Providing review mechanism for tourist.
• To maintain & control the database of tourists’ information.
•Displaying attractive tourist places
• information & route information.
• Providing attractive packages such family, friends, couple,
honeymoon, education tour.
• Traveler group can post that they go any place so user can go there
with them.
• User can post photos and can make comments on them.
• User can create packages.
• Help to make strong relationship with customers so that they can
enjoy their holidays.
• User can book hotel and package via online.
• Giving a variety of travel services that will sure to match all your
priorities.
• User can pay via Baksh, rocket or Nagad.
• User can search hotels and packages to compare price range.
• User can rent a car from pickup point to destinations
• In the future it will be enhanced by providing Tour and Travels
Management System for multiple cities on our websites.
• In future, we will give facility of online donation.
• We will include more functionality as per user require.
• Multiple packages can be booked by one customer at a time.
• Updated feature should be enhanced for all modules.
• Real-time feedback facility available on our website.
• Travels management system will try to serve all expectations.
• Not a single website is ever considering as complete forever firstly
because there is always something new requirement also are growing
day by day.
Figure 1: Login page for Admin Figure 2: Login page for Admin
successful Admin successful
Figure 3: Creating package Figure 4: Creating package
successful
Figure5: manage booking approve or cancel Figure 6: manage booking
approve or cancel

USER PART
Figure 7: user sign in Figure 8: user sign in successful
Figure 9: user package booking Figure 10: user package booking
successful
Figure 11: user package booking history
V. CONCLUSION

This web application was successfully created and stored all the travel admin
tourism packages booking, creation managing and tour details into the database.
Testing concluded that the performance of the system was satisfactory and all
the necessary output was generated. Further enhancements can be made to the
project to make the website function in an attractive and useful manner. It is
concluded that the application works well and satisfy the needs..
ADVANTAGES

• It becomes convenient for users to book their tour online instead of

visiting agency.
• It provides 24/7 service to customers.
• It eliminates the use of paper for storing records of passengers.
• People can book there tour according to there schedule at any time.
• It provides guarantee of obtaining services as it send an automated email
• Gives accurate information
• Simplifies the manual work
• It minimizes the documentation related work
• Provides up to date information
• Friendly Environment by providing warning messages.
• travellers details can be provided
• booking confirmation notification

APPLICATIONS:
• To help tourism companies to manage customers and hotels.
• The system can also be used for both professional and business trips.
• It increases the business connectivity
CHAPTER 3

ANALYSIS AND DESIGN

System analysis is a process of gathering and interpreting facts, diagnosing

problems, and recommending improvements on a system. It requires intensive
communication between the system users and developers, and is an important
phase of any system development process. Fact-gathering techniques such as
interview, observation, questionnaires, and other methods can be used to gather
the information. Analysis follows the problem recognition and feasibility phases
and must be completed before the design phase can begin.

OVERVIEW OF THE EXISTING SYSTEM

The modern computerized system is developed with the aim to overcome the
drawbacks of the existing system. The proposed system has got many
advantages. People from different parts of the world can register very easily.
The current system which is largely a manual system involves a lot of
paperwork at all the levels of the organization. The staff of the organization and
the customers are unhappy with various 3.4 DATA GATHERING TECHNIQUE
USED

3.4.2 OBSERVATIONS

When we went to the central bus stand to get information from the travel agents
for our project, we saw that some errors should improve. One of them is there is
no proper place to stay the passengers until the buses come. So passengers
suffer from the sunshine, rain, dust.
Next thing is there is no proper way to get the bus details for the passengers.
Main way of collecting details is via the booking stand, but if the travel agent is
not on seat, then the passengers have to stay until he comes.

SYSTEM DESIGN
Based on the user requirements and detailed analysis, the new system must be
designed (Chimaek et al, 2007). Design is a creative process. A good design is
the key to effective system because System design is a solution to approach the
creation of a new system.

OUTPUT DESIGN

A quality output is one, which meet the requirement of the end user and presents
the information clearly (Boundy, 1991). In this system the output produced
meets the customer’s requirements and is determined by the input of the
customer, such output includes whether a seat is available, whether a hotel is
available and ticket id etc. this system output is the displayed output on a CRT
LCD screen in a predefined format. The primary consideration we took in the
design of the system output is the information requirement and objectives of the
end users.

INPUT DESIGN

This system uses screens to enter data and check its validity. The input design
consists of a log in screen, textbox for username and password, source and
destination browsing button, menu list for type of hotel, car, date and time,
seats, compress/decompress button. The user is directly involved when working
with the system.
3.5.4 DATABASE REQUIREMENT ANALYSIS: WHAT DATA
IS NEEDED?

List of Entities:

i. Bus
ii. Passenger
iii.Route

2) ROUTE INFORMATION

i.To location

ii.From location

iii.Depart date

iv.Depart time

v.Fare

3) PASSENGER INFORMATION:

i.Name

ii.Mobile number

iii.E-mail

3.7 SYSTEM SPECIFICATION ANALYSIS

The hardware specifications used for the system design are as follows:

i. Notebook with AMD Sempron processor.

ii. 110GB of disk space (minimum) iii.1GB MB of RAM

(minimum)
Besides the hardware specifications, the software specifications were as follows:
i. HTML

ii. Hypertext Processor (PHP) Script Language version 5.2.1

iii.MySQL Database version 5.0.27 iv.PhpMyAdmin Database

Manager version 2.9.2

i. Microsoft Windows 7
Ultimate
v.Dreamweaver version 8.
CHAPTER 4

4.1 HARDWARE REQUIREMENTS

The hardware for the implementation of the proposed system is as follows:

i.Intel i5 processor is recommended. Minimum speed is 1042 MHz or
Higher
ii.1 Gigabyte (GB) or higher of RAM recommended. minimum 512 MB
iii.60GB or higher of HOD recommended.
iv.Internet or a local host.
v.SVGA monitor

4.1.1 SOFTWARE REQUIREMENTS

The software requirements are as follows:

i. Apache server with configuration.
ii. MYSQL database management software iii.Microsoft internet
explorer or any other web browser iv.Windows XP or higher
operating system

4.2 CHOICE PROGRAMMING LANGUAGE

1) JAVASCRIPT: JavaScript also known as ECMAScript is a prototype based

object-oriented scripting language that is dynamic, weakly typed and has first-
class functions. It is also considered a functional programming language like
Scheme because it has and supports high order functions. The primary purpose
for using JavaScript in this system is to write functions that

are embedded in or included from HTML pages and that interact with the
Document Object Model (DOM) of the page. Some simple examples of this
usage are:

i. Validating input values of a web form to make sure that they are acceptable
before being submitted to the server.
ii. Changing images as the mouse cursor moves over them. This effect is often
used to draw the user’s attention to important links displayed as graphical
elements. Because JavaScript code can run locally in a user’s browser (rather
than on a remote server), the browser can respond to user actions quickly,
making an application more responsive. Furthermore, JavaScript code can
detect user actions which HTML alone cannot, such as individual keystrokes.
The wider trend of Ajax programming similarly exploits this strength.

2) PHP:
PHP is a general-purpose scripting language originally designed for web
development
PHP is a free software language that is used to create dynamic web pages. It was
created by Rasmus Lerdorf in 1995 and is installed on more than 20 million
websites and 1 million web servers. HTML and CSS are two of the most
popular markup languages for web pages. HTML is the basic building block of
Webpages and is written with HTML elements consisting of tags, enclosed in
angle brackets (like html>). The purpose of a web browser is to read HTML
documents and compose them into visual or audible web pages.
HTML allows images and objects to be embedded and can be used to create
interactive forms. CSS can be used to define the appearance and layout of text
and other material. The W3C encourages the use of CSS over explicitly
presentational HTML.
CHAPTER 5

EXISTING SYSTEM/ PURPOSED SYSTEM:

EXISTING SYSTEM:

In the present system, a customer has to approach various agencies to find

details of places and to book tickets. This often requires a lot of time and effort.
A customer may not get the desired information from these offices and often the
customer may be misguided. It is tedious for a customer to plan a particular
journey and have it executed properly.

i. All work consider manually.

ii.In Manual Booking System Customer has to go to the Travelling

office.

iii.Ask enquiry for Travelling then Book ticket Finally Paid Payment &

Collect Receipt.

iv.Difficult To Maintain the Customer Details of Package and Payment

Receipt in Register.

v. They Register Tour Package in the notebook.

vi. Add advertisement in Local newspaper or Local Market. vii.Use

Travelling Facility For the Limited Area or Person.

PROPOSED SYSTEM:

The proposed system is a web-based application and maintains a centralized

repository of all related information. The system allows one to easily access the
relevant information and make necessary travel arrangements. Users can decide
about the places where they want to visit and make bookings online for travel
and accommodation. The propose system is highly automated and makes the
travelling activities much easier and flexible. The user can get the very right
information at the very right time. Customers can get the knowledge of the
hotels and vehicles they are going to use in their trip prior to their starting of
trip. This will the travel company as well.

4ANALYSIS/IMPLEMENTATION/ARCHITECR:

•
Data Flow Diagrams (DFD)
•
ER Diagrams
•
Implementation

A Data Flow Diagram (DFD) is a diagram that describes the flow of data
and the processes that change or transform data throughout a system. The Data
Flow Diagram reviews the current physical system, prepares input and output
specification, specifies the implementation plan etc. Four basic symbols are
used to construct data flow diagrams. They are symbols that represent data
source, data flows, and data transformations and data storage. The points at
which data are transformed are represented by enclosed figures, usually circles,
which are called nodes.

Steps to Construct Data Flow Diagrams

Four steps are commonly used to construct a DFD

• Process should be named and numbered for easy reference. Each
name should be representative of the process.
• The direction of flow is from top to bottom and from left to right.
• When a process is exploded into lower-level details they are
numbered.
• The names of data stores, sources and destinations are written in
capital letters

Rules for Constructing a Data Flow Diagram

• Arrows should not cross each other.

• Squares, Circles and files must bear names.
• Decomposed data flow squares and circles can have same names.
• Choose meaningful names for dataflow.
Draw all data flows around the outside of the diagram

Context Level Data Flow Diagram

First level Data Flow Diagram for ADMIN

Request Response
Tour & Travel

ADMIN Customer
Management

Response System Request

Second level Data Flow Diagram for ADMI

Second level Data Flow Diagram for ADMI
ER DIAGRAM Customer and Admin
CHAPTER 6

PROJECT RELATED OTHER CHAPTER

ALGORITHM:

1. Start
2. Take personal details from user(email, phonenumber, name etc).
3.System will ask to the user whether he/she wants to book tour with
hotel or not. 4.If yes then book the tour.
5.If customer want tour with agritourism then system proceed
further booking process (If not then go with first tour). 6.Make
a payment
7.Stop.

RESULT
In webpage of our tour and travel management system when user
click on “About Us” button then it display the whole information
about tour packages.

CONCLUSION
This web application was successfully created and stored all the travel admin
tourism packages booking, creation managing and tour details into the database.
Testing concluded that the performance of the system was satisfactory and all
the necessary output was generated. Further enhancements can be made to the
project to make the website function in an attractive and useful manner. It is
concluded that the application works well and satisfy the needs.

REFERENCES
1. Smith, J. (2018). Tourism Management Systems: A Comprehensive Review. Journal
of Tourism Research, 35(2), 87-105.

2. Johnson, A., & Brown, C. (2019). Implementing an Online Tourism Management

System: Case Study of XYZ Travel Agency. International Journal of Tourism
Management, 42, 156-173.

3. Lee, K., & Kim, S. (2020). Designing a Mobile Tourism Management System for
Sustainable Destination Development. Journal of Sustainable Tourism, 38(4), 321339.

4. Li, M., et al. (2021). An Intelligent Recommender System for Personalized Tourism
Management. Information Systems, 54, 102-120.

5. Wang, H., et al. (2022). Blockchain Technology in Tourism: Opportunities and

Challenges. Journal of Tourism and Hospitality Management, 39, 76-92.