SIR M.
VISVESVARAYA INSTITUTE OF TECHNOLOGY
(Affiliated to Visvesvaraya Technological University, Belagavi)
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
An Project Presentation
On
ONLINE BUS TICKET BOOKING SYSTEM FOR TRAVEL MANAGEMENT
PRESENTED BY- Under the guidance of-
PRITI MONDAL 1MV21CS073 DR Suma Swamy
VAISHNAVI 1MV21CS115 Professor,
VINAY KUMAR MS 1MV21CS119 Dept. of CSE, Sir MVIT
PIYUSH KUMAR 1MV21CS127
1
Table of content:
page no
1. INTRODUCTION TO PROJECT 3
2. PROJECT DESCRIPTION 4
3. ER DIGRAM and UML DIAGRAM 5-6
4. IMPLEMENTATION AND TECHNOLOGY USED 7
5. SCREENSHOTS 8-9
6. CONCLUSION 10
2
1. INTRODUCTION
The Online Bus Ticket Booking System for Travel
Management is a mini project that aims to provide a
convenient and user-friendly platform for travelers to
search and book bus tickets online. This project utilizes
the power of database management using MySQL to
store and manage the necessary information related to
buses, routes, schedules, and bookings.
3
2. PROJECT DESCRIPTION
user registration/login-This allows the user to create account and search for
bus routes,view schedules etc.
features including real time updates-travelers can conviniently receive
updates on bus availability , departure times, pricing.
integrating the system with travel management platforms-enables
coordinators to book bus transportation as a part of a larger itinerary.
providing real time visibility into booking -it provides real-time visibility into
bookings , occupancy levels , and travel expenses.
4
GOALS AND OBJECTIVES
1. UI/UX Excellence:
"Crafting a visually appealing and user-friendly interface to redefine the bus booking experience."
2. Effortless Booking Process:
"Simplifying ticket reservations with a seamless, one-click booking process for ultimate user convenience."
3. Admin Empowerment:
"Empowering administrators with a robust control panel for efficient regulation and management of bus
services."
4. Fortified Data Security:
"Prioritizing data security to ensure user and administrative information remains confidential and
protected."
5. Scalable Performance:
"Building a scalable and high-performance system to handle increased demand and deliver a consistently
responsive service."
3.ER DIAGRAM OF ONLINE BUS TICKET BOOKING SYSTEM:
1.Admin Entity:
·Represents administrators with attributes AID (primary key),
NAME, and PSW.
2.BusDetails Entity:
·Represents bus details with attributes BUS_ID (primary key),
NAME, FARE, NO_OF_SEATS, TYPE, Time, BFROM, BTO,
BNO, and BNAME.
3.BookingDetails Entity:
·Represents booking details with attributes BUS_ID(primary
key), BFROM,BTO, VACANT, and JDATE.
4.Ticket Entity:
·Represents tickets with attributes TID (primary key), SEAT_NO,
U_ID,PNAME, NO_SEAT, B_ID, J_DATE,
TICKET_STATUS, and BOOKING_DATE.
5.UserInfo Entity:
·Represents user information with attributes AGE, UID(primary
key), UName, AADHARNO (unique), PSW, Email, and Name.
5
Relationships:
·"Admin" (AID) is related to "BusDetails" (NAME) with a one-to-many
relationship, indicating that an administrator can manage multiple bus
details.
·"Ticket" (TID) is related to "BusDetails" (BUS_ID) with a one-to-many
relationship, indicating that a ticket can be associated with a specific bus.
·"Ticket" (SEAT_NO) is related to "UserInfo" (U_ID) with a one-to-one
relationship, indicating that a seat is associated with a user.
·"BookingDetails" (BUS ID) is related to "BusDetails" (BUS ID) with a one-
to-one relationship, indicating a specific bus for booking.
UML DIAGRAM OF ONLINE BUS TICKET BOOKING SYSTEM:
6
4. TECHNOLOGY STACK USED:
1. FRONT-END 2. BACK-END
HTML PHP
CSS PHPMYADMIN USED FOR MYSQL DATABASES
JAVASCRIPT XAMPP SERVER
BOOTSTRAP4
7
5. SCREENSHOTS OF OUTPUT:
5.1: FRONT PAGE OF OUR WEBSITE 5.2: DISPLAYING THE BUS DETAILS
8
5.3: FILLING THE BUS DETAILS: 5.4: PASSENGERS DETAILS
9
6. CONCLUSION:
In conclusion, the development of the Online Bus Ticket Booking System has
resulted in a well-organized and user-friendly platform that effectively manages
bus details, user information, ticket bookings, and administrative tasks. The
integration of entities such as Bus Details, Ticket, User_Info, Booking Details, and
Admin ensures a streamlined and secure experience for users, allowing them to
easily search for buses, book tickets, and track their booking history. The system's
robust database design enhances data integrity, providing administrators with a
comprehensive dashboard to manage bus schedules, monitor user activities, and
ensure smooth system operation. Overall, this project demonstrates the
successful application of database management principles in creating an efficient
and scalable solution for online bus ticket booking.
10
11
