UNIVERSITY OF MUMBAI

PROJECT ENTITLED

“Travel and Tourism Management System”

SUBMITTED BY

Raksha Kishnawat
UNDER GUIDANCE OF

Miss. Princi Yadav

SUBMITTED FOR THE FULFILLMENT OF THE

CURRICULUM OF DEGREE OF BACHELOR OF SCIENCE IN
COMPUTER SCIENCE

PILLAI COLLEGE OF ARTS, COMMERCE

& SCIENCE (AUTONOMOUS), NEW
PANVEL 2025-2026
MAHATMA EDUCATION SOCIETY’S
PILLAI COLLEGE OF ARTS
COMMERCE & SCIENCE
(AUTONOMOUS)
(Affiliated to University of Mumbai)
NEW PANVEL -410206 MAHARASHTRA

DEPARTMENT OF COMPUTER SCIENCE

1
 CERTIFICATE

This is to certify that the project entitled “Travel and

Tourism Management System”, is bonafied work of
Mrs. Raksha Kishnawat bearing Seat No: 5403
submitted in partial fulfilment of the requirements for the
award of degree of
BACHELOR OF SCIENCE in COMPUTER SCIENCE
from University of Mumbai.

Date: External Examiner

Internal Guide Coordinator/HOD

College Seal

2
 ACKNOWLEDGEMENT
I take this opportunity to express my sincere gratitude to all those who have contributed, directly
or indirectly, to the successful completion of my mini project titled “Travel and Tourism
Management System (TourEase)”.

I am deeply thankful to my project guide and subject teacher for their valuable guidance,
constant encouragement, and constructive suggestions throughout the project work. Their
support played an important role in the successful completion of this project.

I also express my gratitude to the Head of the Department of Computer Science and all the
faculty members for their academic support and knowledge, which proved helpful during the
course of this project.

I would like to thank the college management for providing the necessary infrastructure and
laboratory facilities required for this work.

Finally, I extend my sincere thanks to my classmates, friends, and family members for their
continuous support, encouragement, and cooperation throughout the project.

Yours faithfully,
Raksha Kishnawat
(Second Year Computer Science)
Table Content
Sr. No. CHAPTERS Page No. Signature

1 CHAPTER 1: INTRODUCTION AND OBJECTIVES

1.1 Overview 6

1.2 Background of the system 6

1.3 Problem Statement 7

1.4 Objectives of the Project 7

1.5 Purpose of the Project 7

3
1.6 Scope of the Project 8

1.7 Limitations of the Project 8

2 CHAPTER 2: LITERATURE REVIEW /

BACKGROUND STUDY

2.1 Overview of Existing Systems 8

2.2 Study of Related Work 9

2.3 Limitations of Existing System 9

2.4 Need for the Proposed System 9

3 CHAPTER 3: Feasibility Study

3.1 Technical Feasibility 10

3.2 Economical Feasibility 10

3.3 Operational Feasibility 10

4 CHAPTER 4: Requirement Analysis

4.1 Functional Analysis 10

4.2 Non-Functional Analysis 11

4.3 Hardware Analysis 11

4.4 Software Analysis 11

4.5 Conceptual Model 11

4.5.1 Database Design 11

4.5.2 ER Diagram 12

4.5.3 Use Case Diagram 13

4
4.5.4 Class Diagram 14

4.5.5 Sequence Diagram 15

4.5.6 Activity Diagram 15

4.5.7 Object Diagram 16

4.5.8 State Diagram 16

4.6.9 Component Diagram 17

5 CHAPTER 5:System Design

5.1 System Designs 18-21

6 CHAPTER 6: CODES

6.1 System Coding, Implementation 22-42

6.2 Testing 42-44

7 CHAPTER 7: CONCLUSION AND FUTURE SCOPE

7.1 Conclusion 45

7.2 Future Enhancements 46

5
 CHAPTER 1

INTRODUCTION
1.1 Overview

The Travel and Tourism industry is one of the fastest-growing sectors worldwide. With
the increasing use of the internet and digital platforms, customers now expect quick,
accurate, and reliable services. Traditional travel planning methods such as visiting
travel agencies, making phone calls, and relying on printed brochures are gradually
becoming obsolete due to inefficiency and lack of flexibility.

A Travel and Tourism Management System is a computerized platform designed to

automate and manage travel-related operations. It provides a centralized environment
where travel agencies can manage packages, bookings, and customer enquiries, while
users can explore destinations, book packages, and communicate with the service
provider easily.

This project aims to design and implement a web-based Travel and Tourism
Management System that ensures smooth interaction between users and
administrators. The system minimizes manual effort, improves data accuracy, and
enhances customer satisfaction.

1.2 Background of the System

In earlier days, travel agencies maintained records manually using registers and files.
Customer details, booking information, and package data were stored on paper, making
the system prone to errors such as duplication, data loss, and mismanagement. As
customer demand increased, it became extremely difficult to manage operations
efficiently.

With advancements in information technology, databases and web applications

replaced manual record keeping. Travel Management Systems emerged as a solution
to handle large volumes of data securely and efficiently. These systems allow real-time
access to information, faster communication, and better decision-making.

The background of this project is rooted in the need for a modern, reliable, and
automated system that simplifies travel planning for customers and operational
management for travel agencies.

6
1.3 Problem Statement

Despite the availability of multiple travel agencies, users often face challenges such as:

●​ Lack of centralized travel information

●​ Difficulty comparing travel packages
●​ Time-consuming booking processes
●​ Poor communication between customers and agencies
●​ Manual data handling leading to errors

Travel agencies also face difficulties in managing customer data, updating packages,
and tracking bookings manually. Therefore, there is a need for a centralized,
automated, and user-friendly Travel and Tourism Management System that
addresses these issues effectively.

1.4 Objectives of the Project

The objectives of this project are:

●​ To develop a web-based system for managing travel and tourism operations

●​ To provide users with easy access to travel package information
●​ To allow users to book travel packages online
●​ To manage customer enquiries efficiently
●​ To provide administrators with control over packages and bookings
●​ To reduce manual work and paperwork
●​ To ensure data accuracy and security
●​ To improve service quality and customer satisfaction

1.5 Purpose of the Project

The primary purpose of this project is to automate the travel booking process and
provide a seamless experience to users. The system serves as a bridge between
customers and travel agencies by offering a transparent and interactive platform.

The project also aims to demonstrate the practical application of database management
systems, web technologies, and software development principles in solving real-world
problems.

7
1.6 Scope of the Project

The scope of the Travel and Tourism Management System includes:

●​ User registration and authentication

●​ Display of available travel packages
●​ Online booking of packages
●​ Management of customer enquiries
●​ Admin control over packages and bookings
●​ Secure storage of data in a database

The system can be extended in the future to include online payment gateways,
feedback systems, and mobile compatibility.

1.7 Limitations of the Project

●​ Online payment is not included in the current version

●​ Internet connectivity is required
●​ The system depends on accurate data input by administrators

CHAPTER 2

1.2 Overview of Existing Systems

Existing travel and tourism management systems can be broadly categorized into traditional
manual systems and basic online platforms. Traditional systems depend heavily on physical
travel agencies, where customers must visit offices, consult agents, and complete bookings
through paperwork or phone communication. These systems are time-consuming, error-prone,
and lack centralized data management.

Some modern systems provide online access to travel information such as destinations, tour
packages, and pricing details. However, many of these platforms function mainly as
informational websites rather than complete management systems. They often do not support
end-to-end booking workflows, automated confirmations, or integrated user authentication.
Administrative operations like updating packages, managing bookings, and maintaining
customer records are usually handled manually or through disconnected tools, leading to
inefficiency and data redundancy.

8
2.2 Study of Related Work
A review of related work in the travel and tourism domain shows that most research focuses on
analytical and theoretical aspects rather than full system implementation. Several studies
analyze tourist behavior, travel demand forecasting, destination recommendation algorithms,
and customer satisfaction metrics using data mining or machine learning techniques. These
works contribute valuable insights but are limited to academic analysis.

Some previously developed systems attempt to digitize travel services, but they often provide
only partial solutions such as online package listings or inquiry forms. Few systems integrate
backend technologies with secure databases, role-based access (user and admin), and
automated communication mechanisms like email notifications. Compared to these studies,
TourEase emphasizes practical application by implementing a complete web-based solution that
combines frontend usability, backend logic, database management, and automated services into
a single platform.

2.3 Limitations of Existing System

Despite technological progress, existing systems exhibit several critical limitations. Most
systems lack automation in booking confirmation and customer communication, requiring
manual follow-ups by administrators. This increases processing time and the possibility of
human errors. Inadequate admin control over package management makes updating or deleting
travel packages inefficient.

Additionally, many systems do not ensure proper data security or structured storage, resulting in
inconsistent or duplicated records. Poor user interface design, limited scalability, and absence of

real-time updates further reduce system effectiveness. These limitations negatively impact user
experience and place a heavy operational burden on travel service providers.

2.3 Need for the Proposed System

The identified limitations create a strong need for an integrated and fully automated Travel and
Tourism Management System. The proposed TourEase system addresses these challenges by
providing a centralized platform with dedicated user and admin modules. Users can easily
register, log in, browse packages, and complete bookings, while administrators can efficiently
manage packages and monitor booking records.

By incorporating a Python-based backend, MySQL database, and automated SMTP email

notifications, TourEase ensures data accuracy, security, and timely communication. The use of
modern frontend technologies enhances usability and accessibility. Overall, the proposed
system bridges the gap between theoretical research and real-world application by delivering a
scalable, efficient, and user-friendly travel management solution.

9
 CHAPTER 3

3 FEASIBILITY STUDY
A feasibility study evaluates the practicality of the proposed system before development.

3.1 Technical Feasibility

The system uses well-established technologies such as HTML, CSS, backend programming
languages, and MySQL database. These technologies are widely supported, easy to implement,
and require minimal hardware resources.

The development environment is stable, and technical skills required for implementation are
readily available. Therefore, the project is technically feasible.

3.2 Economic Feasibility

The project uses open-source tools and technologies, reducing development and maintenance
costs. Automation reduces operational expenses by eliminating manual labor and paperwork.

Thus, the system is economically feasible and cost-effective.

3.3 Operational Feasibility

The system is designed with a simple and intuitive interface. Users can easily navigate through
pages, while administrators can manage operations efficiently.

Minimal training is required, making the system operationally feasible.

CHAPTER 4

4 REQUIREMENT ANALYSIS

4.1 Functional Requirements

●​ User registration and login

●​ Viewing travel packages
●​ Booking packages
●​ Submitting enquiries
●​ Admin management of packages
●​ Admin booking monitoring

10
4.2 Non-Functional Requirements

●​ Security of user data

●​ System reliability
●​ Performance efficiency
●​ Scalability

4.3 Hardware Requirements

●​ Processor: 1.6 GHz or higher

●​ RAM: 4 GB minimum
●​ Storage: Adequate disk space

4.4 Software Requirements

●​ Operating System: Windows 10 or higher

●​ Frontend: HTML, CSS, Bootstrap
●​ Backend: PHP / Python / Java
●​ Database: MySQL

4.5 Conceptual Model

4.5.1 Database Design

The database is the backbone of the system. It stores all essential information securely.

Admin Table: Stores administrator credentials and account details.​

Users Table: Stores user information such as name, email, and contact.​
Packages Table: Stores travel package details including price, duration, and location.​
Bookings Table: Stores booking details and user selections.​
Enquiries Table: Stores customer queries and messages.​
Recommendation Table: Stores recommended package relationships.

11
4.5.2 ER Diagram Explanation

The ER diagram represents entities and relationships within the system. It ensures logical data
organization and avoids redundancy.

Each entity has a primary key, and relationships maintain data consistency across tables.

12
4.5.3 Use Case Diagram Explanation

The Use Case Diagram illustrates interactions between users and the system. It helps identify
system functionality from the user’s perspective.

13
4.5.4 Class Diagram

The Class Diagram represents the structure of the system by showing classes, their attributes,
and relationships. It includes classes such as User, Admin, Package, Booking,User and
Enquiry. This diagram helps in understanding data organization and object relationships within
the system.

14
4.5.5 Sequence Diagram (Booking Process)

The Sequence Diagram illustrates the step-by-step interaction between the user and system
components during the booking process. It shows how a booking request is initiated, processed,
stored in the database, and confirmed

4.5.6 Activity Diagram (User Booking Flow)

The Activity Diagram represents the workflow of user actions such as login, selecting a
package, entering booking details, and confirming the booking. It helps in understanding the
flow of activities in the booking process.

15
4.5.7 Object Diagram

The Object Diagram shows instances of classes at a particular moment in time. It represents
real-time objects such as a specific user, selected package, and booking details, helping to
visualize system data during execution.

4.5.8 State Diagram (Booking Status)

The State Diagram represents different states of a booking, such as Pending, Confirmed, and
Cancelled, and shows how the booking changes from one state to another based on user or
system actions.

16
4.5.9 Component Diagram

The Component Diagram shows the physical components of the system and their interactions. It
includes components such as the user interface, backend logic, database, and email service,
providing an overview of system architecture.

17
 CHAPTER 5
5 System Design
Admin Dashboard Page:-

Add packages:-

18
View Bookings:-

Home Page:-

19
Tour Page:-

Booking Page:-

20
Contact Page:-

21
 CHAPTER 6
6.1 System Coding, Implementation:-

db_connection.py:-
import [Link]

def get_db_connection():
conn = [Link](
host="localhost",
user="root", # your MySQL username
password="Admin123#", # your MySQL password
database="ttm_system" # the database you created
)
return conn

Flask Code:-
from flask import Flask, request, render_template, redirect, url_for,
flash, session
import mysql
from db_connection import get_db_connection
from flask import jsonify
from datetime import datetime
from [Link] import check_password_hash, generate_password_hash

app = Flask(__name__)
app.secret_key = "your_secret_key_here"

[Link]:-
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet"
href="[Link]
[Link]">
<title>TourEase | Home</title>
<link rel="stylesheet" href="/static/css/[Link]">
</head>
<body>

<nav class="navbar">

22
 <div class="logo">
TOUR<span class="mountain">⛰</span>EASE
</div>
<ul>
<li><a href="/">Home</a></li>
<li><a href="/about">About</a></li>
<li><a href="/service">Our Services</a></li>
<li><a href="/tours">Tours</a></li>
<li><a href="/legal">Legal & Policy</a></li>
<li><a href="/contact">Contact</a></li>
<li><a href="/login" class="nav-btn">Login</a></li>
<li><a href="/register" class="nav-btn
register-btn">Register</a></li>
<li><a href="/my-bookings" class="nav-btn cart-link">
<i class="fas fa-shopping-bag"></i>
<span class="cart-count">{{ cart_count }}</span>
</a>
</li>
</ul>
</nav>

<!-- HERO SECTION -->

<section class="hero">
<div class="hero-content">
<h1>TourEase</h1>
<h2>Tour & Travel</h2>
<p>Discover unforgettable destinations, premium tours, and
memories that last a lifetime.</p>
</div>
</section>

<!-- PACKAGES SECTION -->

<section class="packages">
<h2 class="section-title reveal">Our Travel Packages</h2>
<p class="section-desc reveal">
Explore our carefully curated travel packages designed to provide
comfort,
safety, and unforgettable experiences. Each package includes
detailed itineraries,
accommodation, transport, and expert guidance to ensure a
hassle-free journey.
</p>

<div class="package-grid">
<!-- PACKAGE 1 -->
23
 <div class="package-card reveal">
<img src="/static/images/[Link]" alt="Manali Package">
<h3>Manali Hill Station Package</h3>
<p>
Experience the beauty of snow-covered mountains, scenic
valleys,
and adventure activities in Manali. This package includes
sightseeing,
comfortable stays, and guided tours.
</p>
<ul>
<li>✔ 5 Days / 4 Nights</li>
<li>✔ Hotel & Transport Included</li>
<li>✔ Sightseeing & Guide</li>
</ul>
<a href="/manali" class="deal-btn">See More</a>
</div>

<!-- PACKAGE 2 -->

<div class="package-card reveal">
<img src="/static/images/[Link]" alt="Dubai Package">
<h3>Dubai City & Desert Safari</h3>
<p>
Discover the luxury of Dubai with city tours, Burj Khalifa
visit,
and an exciting desert safari experience including
cultural shows
and BBQ dinner.
</p>
<ul>
<li>✔ 4 Days / 3 Nights</li>
<li>✔ Desert Safari & City Tour</li>
<li>✔ Luxury Transport</li>
</ul>
<a href="/dubai" class="deal-btn">See More</a>
</div>

<!-- PACKAGE 3 -->

<div class="package-card reveal">
<img src="/static/images/[Link]" alt="Jaipur Package">
<h3>Jaipur Heritage Tour</h3>
<p>
Explore the royal heritage of Rajasthan with visits to
forts,
palaces, temples, and local markets guided by experienced
professionals.
24
 </p>
<ul>
<li>✔ 3 Days / 2 Nights</li>
<li>✔ Forts & Palaces Tour</li>
<li>✔ Local Guide</li>
</ul>
<a href="/jaipur" class="deal-btn">See More</a>

</div>

<!-- PACKAGE 4 -->

<div class="package-card reveal">
<img src="/static/images/[Link]" alt="Phuket Package">
<h3>Phuket Island Adventure</h3>
<p>
Enjoy crystal-clear waters, island hopping, snorkeling
activities,
and relaxing beach experiences in this exciting tropical
getaway.
</p>
<ul>
<li>✔ 5 Days / 4 Nights</li>
<li>✔ Island Hopping</li>
<li>✔ Snorkeling Included</li>
</ul>
<a href="/phuket" class="deal-btn">See More</a>
</div>

<!-- PACKAGE 5 -->

<div class="package-card reveal center-card">
<img src="/static/images/[Link]" alt="Banff Package">
<h3>Banff Glacier & Lake Tour</h3>
<p>
Witness the breathtaking beauty of the Canadian Rockies
with visits
to Lake Louise, Moraine Lake, and Athabasca Glacier with
expert guidance.
</p>
<ul>
<li>✔ Scenic Lakes</li>
<li>✔ Glacier Visit</li>
<li>✔ Guided Tour</li>
</ul>
<a href="/banff" class="deal-btn">See More</a>
</div>

25
 <div class="view-all-tours reveal" style="text-align: center;
margin-top: 30px;">
<a href="/tours" class="deal-btn">View All Tours</a>
</div>
</div>
</section>

<!-- EXPLORE SECTION -->

<section class="explore reveal">
<div class="explore-container">
<div class="explore-text reveal">
<h2>Explore Your Next Adventure With Us</h2>
<p>
At <strong>TourEase</strong>, we believe that travel is
not just about visiting places,
but about creating lifelong memories. Our expertly curated
tours are designed to offer
comfort, safety, and unforgettable experiences at every
step of your journey.
</p>
<p>
From breathtaking mountains and serene beaches to vibrant
cities and cultural landmarks,
our travel packages are guided by experienced
professionals who ensure a smooth, enjoyable,
and well-planned adventure. We focus on personalized
service, flexible itineraries,
and premium travel arrangements so you can explore the
world stress-free.
</p>
<p>
Whether you are traveling solo, with family, or in a
group, TourEase guarantees authentic
experiences, reliable support, and a journey filled with
excitement, comfort, and discovery.
</p>
</div>
<div class="explore-image reveal">
<img src="/static/images/[Link]" alt="Explore with
TourEase">
</div>
</div>
</section>

<!-- TOUR HIGHLIGHTS -->

<section class="highlights reveal">
26
 <h2>Tour Highlights</h2>
<p>Premium destinations • Trusted service • Best price guarantee</p>
<div class="highlight-grid">
<img src="/static/images/[Link]" class="reveal">
<img src="/static/images/[Link]" class="reveal">
<img src="/static/images/[Link]" class="reveal">
<img src="/static/images/[Link]" class="reveal">
<img src="/static/images/[Link]" class="reveal">
<img src="/static/images/[Link]" class="reveal">
<img src="/static/images/[Link]" class="reveal">
</div>
</section>

<!-- REVIEWS -->

<section class="reviews reveal">
<h2>Customer Reviews</h2>
<div class="review-grid">
<div class="review-box reveal">
⭐⭐⭐⭐⭐
<p>“TourEase made our trip stress-free and memorable.
Everything from booking to sightseeing was perfectly organized. Highly
recommended for hassle-free travel.”</p>
<h4>— Rahul Sharma, India</h4>
</div>
<div class="review-box reveal">
⭐⭐⭐⭐⭐
<p>“Amazing service and well-planned tours. The guides were
friendly and professional. Truly a premium travel experience.”</p>
<h4>— Sneha Patel, Mumbai</h4>
</div>
<div class="review-box reveal">
⭐⭐⭐⭐⭐
<p>“Excellent destinations and smooth arrangements. TourEase
delivered exactly what they promised. Would love to travel again with
them.”</p>
<h4>— Arjun Mehta, Delhi</h4>
</div>
<div class="review-box reveal">
⭐⭐⭐⭐⭐
<p>“From hotels to transport, everything was top-notch. A very
reliable and professional travel company.”</p>
<h4>— Neha Verma, Pune</h4>
</div>
</div>
</section>

27
<footer class="footer">
<div class="footer-container">

<!-- Left Section -->

<div class="footer-section">
<h2 class="footer-logo">Explore</h2>
<p>Discover amazing tours with exclusive offers today!</p>

<ul class="footer-links">
<li><a href="/">Home</a></li>
<li><a href="/about">About Us</a></li>
<li><a href="/services">Our Services</a></li>
<li><a href="/tours">Tours</a></li>
<li><a href="/contact">Contact Us</a></li>
<li><a href="/legal">Legal & Policy</a></li>
<li><a href="/faq">FAQ</a></li>
</ul>
</div>

<!-- Middle Section -->

<div class="footer-section">
<h3>Contact</h3>
<p>Email: info@[Link]</p>
<p>Phone: +91 98765 43210</p>

<div class="social-icons">
<a href="#"><i class="fab fa-facebook-f"></i></a>
<a href="#"><i class="fab fa-instagram"></i></a>
<a href="#"><i class="fab fa-linkedin-in"></i></a>
<a href="#"><i class="fab fa-x-twitter"></i></a>
</div>
</div>

<!-- Right Section -->

<div class="footer-section">
<h3>Why Choose Us</h3>
<ul class="why-us">
<li>✔ Trusted Tour Experts</li>
<li>✔ Best Price Guarantee</li>
<li>✔ Handpicked Packages</li>
<li>✔ 24/7 Customer Support</li>
<li>✔ Safe & Secure Booking</li>
</ul>
</div>

</div>
28
 <div class="footer-bottom">
<p>© 2025 TourEase. All rights reserved.</p>
</div>
</footer>

<script src="/static/js/[Link]"></script>
</body>
</html>

Home flaks code:

# ---------------- Home ----------------
@[Link]("/")
def home():
return render_template("user/[Link]")

[Link]:-

<!-- HERO -->

<section class="tour-hero">
<div class="tour-hero-content">
<h1>Explore Our Tours</h1>
<p>Discover handpicked tour packages designed to give you comfort,
adventure, and unforgettable memories.</p>
</div>
</section>

<!-- TOUR LIST -->

<section class="tour-page">

<!-- PACKAGE 1: Manali -->

<div class="tour-card">
<img src="/static/images/[Link]" alt="Manali Tour">
<div class="tour-info">
<h2>Manali Hill Station Package</h2>
<div class="tour-meta">
<span><i class="fas fa-clock"></i> 5 Days / 4 Nights</span>
<span><i class="fas fa-map-marker-alt"></i> India</span>
<span><i class="fas fa-users"></i> Family / Friends</span>
</div>
<p class="tour-desc">
Experience the beauty of snow-covered mountains, scenic
valleys, and adventure activities in Manali. Includes sightseeing,
comfortable stays, and guided tours.
29
 </p>

<div class="tour-details">
<div>
<h4>Itinerary Highlights</h4>
<ul>
<li>Solang Valley adventure</li>
<li>Rohtang Pass sightseeing</li>
<li>Manali local markets</li>
<li>Paragliding & activities</li>
</ul>
</div>
<div>
<h4>Inclusions</h4>
<ul>
<li>Hotel & Transport Included</li>
<li>Guided sightseeing</li>
<li>Adventure activities</li>
</ul>
</div>
<div>
<h4>Exclusions</h4>
<ul>
<li>Personal expenses</li>
<li>Food outside package</li>
</ul>
</div>
</div>
<div class="tour-footer">
<span class="price">₹18,999 / person</span>
<a href="/manali" class="deal-btn">See Details</a>
<a href="/booking?package=manali&package_id=1"
class="book-btn">Book Now</a>
</div>
</div>
</div>

Tour flask code:-

@[Link]("/tours")
def tours():
conn = get_db_connection()
cursor = [Link](dictionary=True)

[Link]("SELECT * FROM packages")

30
 packages = [Link]()

[Link]()
[Link]()

return render_template("user/[Link]", packages=packages)

[Link]:-
<section class="booking-page">
<div class="booking-container">
<h1>Book Your Tour</h1>
<p>Fill in your details and we will confirm your booking
shortly.</p>
<form id="booking-form">
<label>Selected Package</label>
<input type="text" name="package" id="package" value="{{
package }}" readonly>
<input type="hidden" name="package_id" id="package_id"
value="{{ package_id }}">

<label for="name">Full Name</label>

<input type="text" id="name" name="name" required>

<label for="email">Email</label>
<input type="email" id="email" name="email" required>

<label for="phone">Contact Number</label>

<input type="tel" id="phone" name="phone" required>

<label for="guests">Number of Guests</label>

<input type="number" id="guests" name="guests" min="1"
value="1" required>

<label for="date">Travel Date</label>

<input type="date" id="booking_date" name="booking_date"
required>

<label for="requests">Special Requests</label>

<textarea id="requests" name="requests"></textarea>

<button type="submit" class="book-btn">Confirm

Booking</button>
</form>

<div id="success-popup">Booking Successful! 🎉</div>

31
 </div>
</section>
<script>
const form = [Link]('booking-form');
const popup = [Link]('success-popup');

[Link]('submit', function(e){
[Link]();
const formData = new FormData(form);

fetch('/booking', {
method: 'POST',
body: formData
})
.then(res => [Link]())
.then(data => {
if([Link]){
[Link] = 'block';
[Link]();
setTimeout(() => [Link] = 'none', 3000);
} else {
alert([Link] || "Something went wrong!");
}
})
.catch(err => {
[Link](err);
alert("Error submitting booking!");
});
});
</script>

</body>
</html>

Booking flask code:-

@[Link]("/booking", methods=["GET", "POST"])
def booking():

# ---------- GET ----------

if [Link] == "GET":

if "user_id" not in session:

return redirect(url_for("login"))

package_name = [Link]("package")
32
 package_id = [Link]("package_id")

if not package_name or not package_id:

return redirect("/tours")

return render_template(
"user/[Link]",
package=package_name,
package_id=package_id
)

# ---------- POST ----------

try:
if "user_id" not in session:
return jsonify({"success": False, "error": "Login required"}),
401

user_id = session["user_id"]

package_id = [Link]("package_id")
package_name = [Link]("package")
booking_date = [Link]("booking_date")
name = [Link]("name")
email = [Link]("email")
phone = [Link]("phone")
guests = [Link]("guests")
requests_text = [Link]("requests")

if not all([package_id, package_name, booking_date, name, email,

phone, guests]):
return jsonify({"success": False, "error": "All fields are
required"}), 400

conn = get_db_connection()
cursor = [Link]()

[Link]("""
INSERT INTO bookings
(user_id, package_id, package_name, booking_date, name, email, phone,
guests, requests)
VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s)
""", (
user_id,
package_id,
33
 package_name,
booking_date,
name,
email,
phone,
guests,
requests_text
))

[Link]()
[Link]()
[Link]()

return jsonify({"success": True})

except Exception as e:
print("Booking Error:", e)
return jsonify({"success": False, "error": "Server error"}), 500

my_booking.html:-
<!DOCTYPE html>
<html>
<head>
<title>My Booked Packages</title>
<link rel="stylesheet" href="/static/css/[Link]">
</head>
<body>

<h2>My Booked Packages</h2>

{% if bookings %}
<table>
<tr>
<th>Package</th>
<th>Booking Date</th>
<th>Guests</th>
<th>Action</th>
</tr>

{% for b in bookings %}
<tr>

34
 <td>{{ b.package_name }}</td>
<td>{{ b.booking_date }}</td>
<td>{{ [Link] }}</td>
<td>
<a href="/cancel-booking/{{ b.booking_id }}"
onclick="return confirm('Cancel this booking?')"
class="cancel-btn">
Cancel
</a>
</td>
</tr>
{% endfor %}
</table>
{% else %}
<p style="text-align:center;">No package found</p>
{% endif %}

</body>
</html>

my_booking flask code:-

@[Link]("/my-bookings")
def my_bookings():

if "user_id" not in session:

return redirect(url_for("login"))

conn = get_db_connection()
cursor = [Link](dictionary=True)

[Link]("""
SELECT
booking_id,
package_name,
booking_date,
guests,
created_at
FROM bookings
WHERE user_id = %s
ORDER BY created_at DESC
""", (session["user_id"],))

bookings = [Link]()
[Link]()
[Link]()
35
 return render_template("user/my_booking.html", bookings=bookings)

@[Link]("/cancel-booking/<int:booking_id>")
def cancel_booking(booking_id):

if "user_id" not in session:

return redirect(url_for("login"))

conn = get_db_connection()
cursor = [Link]()

[Link]("""
DELETE FROM bookings
WHERE booking_id = %s AND user_id = %s
""", (booking_id, session["user_id"]))

[Link]()
[Link]()
[Link]()

flash("Booking cancelled successfully", "success")

return redirect(url_for("my_bookings"))

Admin_packages.html:-
{% extends "admin/admin_layout.html" %}

{% block content %}
<h1 class="page-title"> ➕ Add Tour Package</h1>
<link rel="stylesheet" href="/static/css/[Link]">

<form class="card-form" method="POST">

<input type="text" name="name" placeholder="Package Name" required>
<input type="text" name="location" placeholder="Location" required>
<input type="number" name="price" placeholder="Price" required>
<input type="text" name="duration" placeholder="Duration" required>
<input type="text" name="guest_type"placeholder="Guest Type (Family /
Couple)" required>
<textarea name="description" placeholder="Description"></textarea>
<input type="text" name="image" placeholder="Image URL">

<button type="submit">Add Package</button>

</form>
{% endblock %}

36
Add Packages flask code:-
# ---------------- ADD PACKAGE ----------------
@[Link]('/admin/add_package', methods=["GET", "POST"])
def add_package():
if "admin_id" not in session:
flash("Please login first", "error")
return redirect(url_for("admin_login"))

if [Link] == "POST":
name = [Link]("name")
description = [Link]("description")
price = [Link]("price")
duration = [Link]("duration")
location = [Link]("location")
guest_type = [Link]("guest_type")
image = [Link]("image")

if not all([name, description, price, duration, location, guest_type]):

flash("All required fields must be filled", "error")
return redirect(url_for("add_package"))

try:
conn = get_db_connection()
cursor = [Link]()

[Link]("""
INSERT INTO packages
(name, description, price, duration, location, guest_type, image,
admin_id)
VALUES (%s,%s,%s,%s,%s,%s,%s,%s)
""", (
name,
description,
price,
duration,
location,
guest_type,
image,
session["admin_id"]
))
[Link]()

37
 [Link]()
[Link]()

flash("Package added successfully!", "success")

return redirect(url_for("manage_packages"))

except Exception as e:
print("Add Package Error:", e)
flash("Something went wrong. Try again.", "error")
return redirect(url_for("add_package"))

return render_template("admin/admin_package.html")

View_booking.html:-
{% extends "admin/admin_layout.html" %}

{% block content %}
<h1 class="page-title"> 📖 All Bookings</h1>
<link rel="stylesheet" href="/static/css/[Link]">

<div class="table-box">
<table>

<tr>
<th>User</th>
<th>Package</th>
<th>Date</th>
<th>Guests</th>
</tr>

{% for b in bookings %}
<tr>
<td>{{ [Link] }}</td>
<td>{{ b.package_name }}</td>
<td>{{ b.booking_date }}</td>
<td>{{ [Link] }}</td>
</tr>
{% endfor %}
</table>
</div>
{% endblock %}

38
View booking flask code:-
# ---------------- VIEW BOOKINGS ----------------
@[Link]('/admin/bookings')
def view_bookings():
if "admin_id" not in session:
flash("Please login first", "error")
return redirect(url_for("admin_login"))

conn = get_db_connection()
cursor = [Link](dictionary=True)

[Link]("SELECT * FROM bookings")

bookings = [Link]()

[Link]()
[Link]()

return render_template("admin/view_booking.html", bookings=bookings)

View_enquireies.html
{% extends "admin/admin_layout.html" %}

{% block content %}
<h1 class="page-title"> 📩 Enquiries</h1>
<link rel="stylesheet" href="/static/css/[Link]">

<div class="table-box">
<table>
<tr>
<th>Name</th>
<th>Email</th>
<th>Message</th>
</tr>

{% for e in enquiries %}
<tr>
<td>{{ [Link] }}</td>
<td>{{ [Link] }}</td>
<td>{{ [Link] }}</td>
</tr>
{% endfor %}
</table>
</div>
{% endblock %}
39
view_enquiries flask code:-
# ---------------- VIEW ENQUIRIES ----------------
@[Link]('/admin/enquiries')
def view_enquiries():
if "admin_id" not in session:
flash("Please login first", "error")
return redirect(url_for("admin_login"))

conn = get_db_connection()
cursor = [Link](dictionary=True)

[Link]("SELECT * FROM enquiries")

enquiries = [Link]()

[Link]()
[Link]()

return render_template("admin/view_enquires.html",
enquiries=enquiries)

[Link]:-

// ----------------------------
// SCROLL REVEAL EFFECT
// ----------------------------
[Link]("DOMContentLoaded", () => {
const reveals = [Link](".reveal");

function revealOnScroll() {
const windowHeight = [Link];
const revealPoint = 120;

[Link](el => {
const elementTop = [Link]().top;

if (elementTop < windowHeight - revealPoint) {

[Link]("active");
}
});
}

[Link]("scroll", revealOnScroll);

40
 revealOnScroll();
});

// ----------------------------
// BOOK BUTTON REDIRECT TO BOOKING PAGE
// ----------------------------
[Link](".book-btn").forEach(btn => {
[Link]("click", function () {

// Redirect to booking page with package name

const selectedPackage = [Link];
[Link] =
`/booking?package=${encodeURIComponent(selectedPackage)}&package_id=${this
.[Link]}`;
});
});
// ----------------------------
// AJAX BOOKING FORM SUBMISSION
// ----------------------------
const bookingForm = [Link]('booking-form');
const successPopup = [Link]('success-popup');

if (bookingForm) {
[Link]('submit', function(e) {
[Link](); // Prevent normal form submission

const formData = new FormData(bookingForm);

// No need to include hidden package_id — your readonly input
'package' is already included

fetch('/booking', {
method: 'POST',
body: formData
})
.then(res => [Link]())
.then(data => {
if ([Link]) {
[Link] = "/my-bookings";
const packageValue =
[Link]('package').value; // store readonly package
[Link]();
// restore package value after reset
[Link]('package').value = packageValue;

41
 setTimeout(() => [Link] = 'none',
3000);
} else {
alert([Link] || "Something went wrong!");
}
})
.catch(err => {
[Link](err);
alert("Error submitting booking!");
});
});
}

6.2TESTING
Testing is a critical phase in the software development life cycle that ensures the developed
system works as intended and meets all specified requirements. For the TourEase Travel and
Tourism Management System, testing was carried out to verify functionality, reliability, security,
and usability of both user and admin modules. The main objective of testing was to identify and
eliminate errors before deployment and to ensure a smooth user experience.

Objectives of Testing
The primary objectives of testing in the TourEase system are:

●​ To verify that all system features function correctly

●​ To ensure accurate handling of user inputs and database operations
●​ To validate secure user authentication and authorization
●​ To confirm reliable booking and package management
●​ To detect and fix errors, bugs, and performance issues

Testing Strategy
The testing process involved multiple levels of testing, including unit testing, integration testing,
system testing, and user acceptance testing. Each module was tested independently and then
tested as part of the complete system to ensure seamless interaction between components
such as frontend, backend, and database.

42
Types of Testing Performed
1. Unit Testing

Unit testing was performed on individual modules such as user registration, login authentication,
package management, and booking functionality. Each function and route in the backend was
tested to ensure correct input processing and output generation.

Example:

●​ Testing user login with valid and invalid credentials

●​ Testing package addition and deletion by admin

2. Integration Testing

Integration testing ensured that different modules of the system work together properly. The
interaction between frontend forms, backend logic, and MySQL database was tested to verify
data flow and consistency.

Example:

●​ Booking data correctly stored in the database

●​ Packages displayed correctly on the user interface

3. System Testing

System testing was conducted on the complete TourEase application to validate overall system
behavior. All features were tested in a real-time environment to ensure the system meets
functional and non-functional requirements.

Example:

●​ End-to-end booking process

●​ Admin viewing and managing bookings

4. User Acceptance Testing (UAT)

User acceptance testing was performed to ensure that the system meets user expectations and
is easy to use. Test users interacted with the system to verify usability, navigation, and
responsiveness.

Example:

●​ Ease of browsing travel packages

●​ Simplicity of booking process

43
Testing Tools Used
●​ Manual Testing for user interface and navigation
●​ Browser Testing using Chrome and Edge
●​ MySQL for database validation
●​ Flask Debug Mode for backend error detection

Test Results and Observations

All critical functionalities of the TourEase system were tested successfully. Minor issues related
to form validation and UI alignment were identified and corrected. The system demonstrated
stable performance, accurate data handling, and efficient package management.

Conclusion of Testing
The testing phase confirmed that the TourEase Travel and Tourism Management System is
reliable, secure, and user-friendly. The system meets all functional requirements and performs
efficiently under normal usage conditions. Proper testing ensured error-free operation and
improved overall system quality, making it ready for deployment.

44
 CHAPTER 7

7.1 Conclusion
The Travel and Tourism Management System has been successfully designed and implemented
to automate and streamline the complete travel management process. The system replaces
traditional manual operations with a centralized, web-based platform that efficiently manages
tour packages, bookings, user information, and administrative activities. By integrating
user-friendly interfaces with a secure backend, the system ensures accurate data handling,
faster processing, and improved reliability.

This project significantly enhances operational efficiency by reducing human errors, minimizing
paperwork, and enabling real-time access to travel information. Customers can easily explore
tour packages, make bookings, and manage their travel plans from a single platform, which
improves overall customer satisfaction. From the administrator’s perspective, the system
provides better control over packages, bookings, and user records, ensuring smooth
management of business operations.

The system successfully fulfills all the defined objectives of the project, including automation,
data security, scalability, and ease of use. Overall, the Travel and Tourism Management System
proves to be a robust, reliable, and effective solution for modern travel agencies, offering a
strong foundation for future enhancements and technological integration.

7.2 Future Scope

The functionality of the Travel and Tourism Management System can be further expanded with
the following enhancements:

1.​ Email Recommendations​

The system can be enhanced to send automated email recommendations to users
based on their booking history, preferences, and browsing behavior. Personalized travel
suggestions, seasonal offers, and promotional packages can be delivered directly to
customers’ email addresses, improving engagement and customer retention.​

2.​ Payment Gateway Integration​

Integrating secure online payment gateways such as UPI, credit/debit cards, and net
banking will allow users to make instant online payments. This feature will improve
transaction convenience, reduce booking delays, and enhance trust and security in the
system.​

3.​ Admin Package Update Facility​

The admin module can be extended to allow administrators to update tour packages
dynamically. Features such as modifying prices, schedules, availability, images, and
descriptions in real time will help keep the package information accurate and up to date
without requiring technical intervention.

45
4.​ Map Integration​
Integrating interactive maps (such as Google Maps) will allow users to view destination
locations, routes, nearby attractions, and hotels. This feature will enhance user
experience by providing visual navigation support and helping customers make better
travel decisions

THANK YOU!!

46