A

Project Report
On
“ Design web page project an image editing tools ”

Submitted & Presented in the fulfillment of the

requirement for the award of
Diploma in Information Technology.
To
Maharashtra state Board of Technical Education, Mumbai
By

Ms.Kale.S.R
Ms. Kole.N.S
Mr.Chavan.P.A
Ms. Chavan.P.L

Under The Guidance of

Prof. Godase.S.B

Department of
Information Technology
NEW SATARA COLLEGE OF ENGINEERING AND
MANAGMENT, KORTI-PANDHARPUR.

A.Y.2023-24
 DEPARTMENT OF Information Technology
NEW SATARA COLLEGE OF ENGINEERING AND
MANAGEMENT KORTI-PANDHARPUR.

CERTIFICATE

This is to certify that the project report

“Design web page project an image editing
Tools” has been presented successfully and
submitted by…

Name of stud Entrollment.No

Ms.Kale.S.R (23213100274)
Ms.Kole.N.S (23213100270)
Mr.Chavan.P.A (23213100271)
Mr.Chavan.P.L (23213100272)

Student of Information Technology class in the fulfilment for the award of Diploma in
Information Technology as per curriculum laid by the Maharashtra State
Board of Technical Education, MUMBAI during the academic year 2023-24.

Subject Teacher H.O.D. Principal

Prof. Godase.S.B Prof. Puri.S.B Prof. Londhe.V.H.
 DECLARATION

We hereby declare that, Dissertation entitled “Design web page project an

image editing tools ” is completed andsubmitted by me for the award of
diploma engineering in Information And Technology, NEW SATARA COLLEGE OF
POLYTECHNIC AND MANAGEMENT, KORTI, PANDHARPUR.

Has been previously presented and to the best of my knowledge, for the award of
diploma engineering title of this or any other university or examination body.

Place –

KORTI Date -
 Acknowledgement

We feel happiness in forwarding this project design report as an image of

sincere efforts the successful design report reflects efforts of our guide in giving
us good information. Our sincere thanks to our guide Prof. Chougule G.B who
has been a constant source of inspiration and guiding star in achieving our goal.

We express our deep gratitude to all staff members who lead us their
valuable support and co-operation.

We are also equally indebted to our principal Prof. Londhe V.H. for his
valuable help whenever needed.

At last, we thank all those who directly or indirectly encouraged and helped us
 INDEX

Sr.no Title Page no

1 Introduction

2 Project Overview

3 Features

4 Getting Started

5 Conclusion

6 Reference

5
Introduction
11

Traveling allows us to explore new places, cultures, and perspectives.

The growth of the internet has made a significant impact on the travel
industry, providing travelers with the convenience of purchasing travel
tickets online from their own homes. This project aims to design the
database system of an online travel ticket purchasing platform that
caters to both customers and travel agencies.

12
Project Overview

In this project, we will develop a comprehensive online travel ticket

booking platform. The system will handle various types of travel
options including trains, buses, and airplanes, with a focus on dynamic
seat management. Users will have the flexibility to register and log in
using either their phone numbers or email addresses, enhancing the
authentication process's convenience and security. The project will
encompass three types of users: passengers, travel agency managers,
and super admins.

/Travel-Management-System
├── /ERD
│ └── ERD.png
├── /Code
│ ├── /Queries
│ │ ├── /Tasks
│ │ │ ├── passengerTasks.sql
│ │ │ ├── superAdminTasks.sql
│ │ │ ├── TAMTasks.sql
│ │ │ └── userTasks.sql
│ │ ├── createTables.sql
│ │ ├── enums.sql
│ │ ├── insert.sql
│ │ └── triggerFunctions.sql
│ ├── main.py
│ ├── sqlRunner.py
│ └── triggerRunner.py
├── README.md
└── LICENSE

13
Features
 Database-based: Most of the constraints and features have been handled in the
database instead of the back end.

 Database Schema and Functionality: The schema has tables for users, travels,
tickets, orders, agencies, discounts, support tickets, vehicles, stations, etc.
Procedures manage reservation, ordering, payment, tracking, and support.

 Security: The process of user registration encompasses the utilization of a one-

time password (OTP) mechanism, conveyed through either SMS or email. These
OTPs are endowed with a finite validity period, necessitating their validation within
the designated timeframe to fulfill the account verification procedure. The
imperative of securely storing passwords is underscored, serving the dual purpose
of fortifying database security and safeguarding user information.

 Support System: The platform enables online communication between customers,

managers, and support services. It includes an online support system for improved
customer-manager interaction. Users create support tickets for queries and can
exchange messages, maintaining clear communication. Additional features like
message status indicators can enhance user experience.

 Travels: The platform facilitates various travel modes, providing information such
as date, time, vehicle type, price, and seat availability. It encompasses Train, Bus,
and Airplane travel types, the latter of which includes both domestic and
international options. Each travel type includes details about date, time, vehicle
type, price, and available seats. Dynamic updates to seat availability are essential
after passenger interactions to maintain accuracy.

14
 Users: This project supports three types of users with different roles:
o Passenger: After registration, users gain access to a personalized panel
containing personal details. Passengers can reserve, order, and pay for
tickets, track order statuses, and apply discounts using codes. They can also
search for tickets using various parameters and rate past travels.
o Travel Agency Manager: Incorporating new travel choices, statistical
insights, and agency-related travel filtering are prominent features. Managers
have the prerogative to append fresh itineraries and employ filters for
agency-associated travels based on diverse criteria. They can access
pertinent statistics such as top-selling journeys, highest revenue, best
ratings, popular destinations, and more. Managers can also retrieve data on
the highest-paying customers for travels within a specific month, limited to
the top 5.
o Super Admin: Super administrators possess the capability to initiate chat
dialogues with both customers and travel agency managers within the
confines of the support system. This privileged group retains access to the
complete spectrum of ticket generation and messaging functionalities
inherent to the online support system.

15
Getting Started
1. Clone this repository.

2. Set up your database according to the schema provided in the ERD.

3. Install the required dependencies listed in the 'requirements.txt' file.

4. Configure your server settings as needed.

5. Run the application by executing the main.py script.

6. Utilize the sqlRunner.py script to execute SQL queries.
7. Use the triggerRunner.py script to run trigger functions.

Warning: Make sure the database connection in main.py before running.

Conclusion
The Travel Management System project aims to create a user-friendly and feature-
rich platform for both travelers and travel agency managers. By carefully
designing the database schema and incorporating various functionalities such as
dynamic seat management, authentication, discount application, and support
interactions, this project aims to enhance the travel booking experience. Through
this project, we strive to showcase the fusion of technology and travel to provide
users with a convenient and efficient way to explore the world.

16