VISVESVARAYA TECHNOLOGICAL UNIVERSITY

BELAGAVI–590018
2025-2026
A
DBMS Project Report
On
“BUS TICKET BOOKING SYSTEM”
Submitted in the partial fulfillment of the requirements for the IV Semester DBMS –
BCS403 for the award of the degree of
Bachelor of Engineering
In
Computer Science and Engineering
Submitted By
POORVIRAJ.M
1GV24CS128
Under the guidance of
Asst Prof. Rakshita M
&
Asst Prof. Sharmila Kumari N
Dept. of CSE, Dr. TTIT, K.G.F
Dr. T. THIMMAIAH INSTITUTE OF TECHNOLOGY
Approved by AICTE, Govt. of India, New Delhi
Affiliated to Visvesvaraya Technological University, Belagavi.
Accredited by NBA (CSE, ECE, EEE, ME & MNE Programs)
Accredited by NAAC with 'A' Grade
 Dr. T. THIMMAIAH INSTITUTE OF TECHNOLOGY
Approved by AICTE, Govt. of India, New Delhi
Affiliated to Visvesvaraya Technological University, Belagavi.
Accredited by NBA (CSE, ECE, EEE, ME & MNE Programs)
Accredited by NAAC with 'A' Grade
Oorgaum, Kolar Gold Fields-5
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
CERTIFICATE
This is to Certify that the DBMS Mini Project entitled “BUS TICKET BOOKING SYSTEM” is a
Bonafide work carried out by POORVIRAJ.M (1GV24CS128) in the partial fulfillment for the
award of degree of Bachelor of Engineering in Computer Science and Engineering of the
Visvesvaraya Technological University, Belagavi during the year 2025- 2026. It is certified that all
corrections suggestions indicated for the assessment have been incorporated in the DBMSProject
Report deposited in the departmental library. The Report approved as it satisfies the academic
requirement in respect of DBMS(BCS403) prescribed for the Bachelor of
…..…………….………………………………… ….………………………………………………..
Signature of Guide Signature of HOD
ASST PROF. SHARMILA KUMARI N Dr. GEETHA C MEGHARAJ,
Dept. Of CSE, Dr. TTIT, K.G.F Professor and Head, Dept. Of CSE,
& Dr. TTIT, K.G.F
ASST PROF. RAKSHITA M
Dept. Of CSE, Dr. TTIT, K.G.F
 ACKNOWLEDGEMENT
I consider it a privilege to express my sincere gratitude and respect to all those who
guided and inspired me throughout this technical seminar.
It is with the profound feelings of gratitude I would like to express my sincere thanks to our
institution Dr. T. THIMMIAH INSTITUTE OF TECHNOLOGY, K.G.F for providing
excellent infrastructure for successful completion of this DBMS Project.
I wish to express a whole hearted thanks to Dr. SYED ARIFF, Principal, Dr. TTIT,
K.G.F for his kind support in carrying out this DBMS Project.
I would like to extend hearty thanks to Dr. GEETHA C MEGHARAJ, Professor and Head,
Dept. of CSE, Dr. TTIT, K.G.F for being a constant support of encouragement to carry out
the DBMS Project successfully.
I would like to extend hearty thanks to my guide [Link]. SHARMILA KUMARI N &
[Link] RAKSHITA M, Dept. of CSE, Dr. TTIT, KGF for their valuable suggestions,
guidance and support in the completion of this DBMS Project.
I would like to thank all teaching and non-teaching staff of Dept. of CSE, Dr. TTIT,
K.G.F who were directly and indirectly supported for carrying out this DBMS Mini Project
successfully.
I extend my hearty thanks to my parents, friends for all the moral support provided
during the preparation for the DBMS Project.
POORVIRAJ.M
1GV24CS128
I
 ABSTRACT
The Bus Ticket Booking System is a web-based application developed to simplify and automate
the process
of reserving bus tickets. The system enables passengers to search for available buses, view
schedules, select
seats, make online payments, and receive electronic tickets instantly. It eliminates the
limitations of
traditional manual booking methods by providing a fast, reliable, and user-
friendly platform that can be
accessed anytime and from anywhere.
The system consists of various modules such as user management, bus management,
booking management, and payment processing. It maintains all booking and passenger
information in a
centralized database, ensuring data accuracy and security. Administrators can
efficiently manage routes,
schedules, buses, and booking records through an administrative dashboard. The integration
of secure
payment gateways ensures safe and convenient financial transactions.
This project improves operational efficiency, reduces paperwork, minimizes human errors,
and enhances customer satisfaction. The Bus Ticket Booking System provides a
practical solution for modern transportation services by offering real-time seat availability,
instant confirmations, and efficient record management. Future enhancements such as
GPS tracking, mobile applications, and AI-based recommendations can further improve
the system's functionality and user experience
II
Sl. No. CHAPTERS Page No
1. Acknowledgement i
2. Abstract ii
3. Table of Contents iii
4. List of Figures iv
5. INTRODUCTION 1
SYSTEM ANALYSIS
2.1 EXISTING SYSTEM
2.2 PROPOSED SYSTEM
2.3 AIM
6. 2-8
2.4 OBJECTIVES
2.5 TECHNOLOGY USED
2.6 SYSTEM REQUIREMENTS
REQUIREMENT SPECIFICATION
7. SOFTWARE REQUIREMENTS 9-10
HARDWARE REQUIREMENTS
SYSTEM DESIGN
ER DIAGRAM
8. SCHEMA DIAGRAM 11
DATA FLOW DIAGRAM
DATA BASE TABLES
9. 12
10. IMPLEMENTATION 13-20
11. RESULTS AND DISCUSSION 21-22
12. SNAPSHOTS 23-24
13. FEATURE ENHANCEMENT 25
14. CONCLUSION 26
15. REFERENCE 27-28
III
 LIST OF FIGURES
Fig1.1 Bus Ticket Booking System 1
Fig2.1 Existing System 2
Fig2.2 Proposed System Analysis 3
Fig2.3 Aim Analysis 4
Fig2.4 Objectives of Analysis 5
Fig2.5 Technology Usage Analysis 6
Fig2.6 System Requirement 8
Fig4.1 ER, System and Data Flow Diagram 11
Fig9.1 Database Table 12
Fig10.1 Implementation 1 16
Fig10.2 Implementation 2 16
Fig10.3 Implementation 3 17
Fig10.4 Implementation 4 17
Fig10.5 Implementation 5 18
Fig10.6 Implementation 6 18
Fig10.7 Implementation 7 19
Fig10.8 Implementation 8 19
Fig10.9 Implementation 9 20
Fig10.10 Implementation 10 20
Fig11.1 Project overview 21
Fig11.2 Stored Database 21
IV
 BUS TICKET BOOKING SYSTEM 2025-2026
INTRODUCTION
The Bus Ticket Booking System is a computerized application developed to simplify and automate the process of booking bus tickets. In the
modern era, the rapid growth of internet technology has transformed the way people access transportation services. Traditional ticket
booking methods often require passengers to visit booking counters, stand in long queues, and spend considerable time completing
reservations. These manual processes can lead to errors, inconvenience, and inefficient management of booking records. To overcome
these challenges, the Bus Ticket Booking System provides an online platform that enables passengers to book tickets quickly and conveniently
from anywhere at any time.
The system allows users to search for available buses based on source, destination, and travel date. Passengers can view bus schedules, compare
ticket prices, select preferred seats, and complete bookings through secure online payment methods. Once the payment is successful, the
system generates an electronic ticket that can be downloaded or printed for future reference. This automated approach not only saves time but
also enhances the overall travel experience by providing real-time information and instant booking confirmation.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
NEED FOR SYSTEM
Traditional ticket booking methods often require passengers to wait in long queues
and depend on manual record management. Such systems are time-consuming and
prone to errors. With increasing internet usage and digital transactions, there is a
need for an automated booking system that offers quick access to bus schedules, seat
availability, and online payments. This system provides convenience and improves
operational efficiency.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
Objectives of the System
The primary objective of the Bus Ticket Booking System is to provide a fast,
reliable, and secure platform for booking bus tickets. It aims to reduce manual
effort, improve customer convenience, ensure real-time seat availability, and
facilitate online payment options. The system also helps transport operators
manage schedules, bookings, and passenger information efficiently through a
centralized database.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
Existing System
In the traditional booking system, passengers usually visit a ticket counter to reserve seats. Staff
members manually verify seat availability and issue tickets. This process consumes significant time
and may result in errors in ticket allocation or record maintenance. Moreover, passengers cannot
easily access information regarding bus schedules, routes, or cancellations without visiting the
booking office.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
USER MODULE
The User Module is responsible for all activities performed by passengers within the system. Users can
create accounts, log in securely, search for available buses, select seats, make bookings, and view booking
history. This module provides a simple and user-friendly interface that allows passengers to manage their
travel plans conveniently. It also enables users to update personal information and receive booking
confirmations instantly.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
BUS MANAGEMENT SYSTEM
The Bus Management Module handles all information related to buses and transportation services.
Administrators can add bus details, update route information, define seating capacity, and schedule
departure and arrival times. This module ensures that passengers receive accurate travel information.
Proper bus management improves operational efficiency and helps maintain organized transportation
records within the system.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
FUTURE ENHANCEMENTS
Future improvements can make the system more advanced and user-friendly. Features such as GPS-based
bus tracking, AI-powered travel recommendations, multilingual support, digital wallets, and instant
notifications can be integrated. Mobile applications and predictive analytics may further enhance
customer experience and operational efficiency, helping transportation services adapt to modern
technological advancements.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
Conclusion
The Bus Ticket Booking System is an efficient and user-friendly application designed to simplify the
process of booking, managing, and canceling bus tickets. It eliminates the need for manual ticket
reservation by providing an online platform where passengers can easily search routes, check seat
availability, select preferred seats, and make secure payments. The system helps reduce paperwork,
minimizes human errors, and saves valuable time for both passengers and bus operators.
By maintaining a centralized database, the application ensures accurate record management, real-time
updates, and better customer service. Features such as user registration, ticket generation, booking
history, cancellation options, and payment integration improve the overall travel experience. The system
also enhances operational efficiency by automating scheduling, seat allocation, and report generation.
In conclusion, the Bus Ticket Booking System is a reliable and modern solution for transportation
management. It increases convenience, improves service quality, and supports the digital transformation
of the travel industry. With future enhancements such as mobile applications, GPS tracking, and AI-
based route optimization, the system can become even more efficient and beneficial for users and
transport organizations.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
IMPLEMENTATION
Bus Details Management Module
This module is responsible for storing and managing bus information within the system. The details
include Bus ID, Bus Name, Source, Destination, and Total Seating Capacity. The program uses a
dictionary data structure to maintain bus records and provides a function to display all available buses.
This module acts as the foundation of the booking system because all reservation operations depend on
the availability of bus information.
Passenger Registration Module
The Passenger Registration Module collects and stores passenger information such as Passenger ID,
Name, Age, Gender, and Mobile Number. The entered details are validated and stored in a passenger
database. This module ensures that every booking is associated with a valid passenger record. The
registration process helps maintain accurate customer information and simplifies ticket management
operations.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
IMPLEMENTATION
Seat Availability and Ticket Booking Module
The Seat Availability Module monitors all seats available in a particular bus and displays vacant seats to
the user. It continuously updates seat status whenever a booking or cancellation is performed. The Ticket
Booking Module allows passengers to reserve seats by selecting an available seat number. Once the
booking is successful, the seat status changes from Available to Booked, preventing duplicate reservations
and ensuring data consistency.
Ticket Cancellation and Fare Calculation Module
The Ticket Cancellation Module allows passengers to cancel their reservations whenever required. After
cancellation, the selected seat becomes available again for future bookings. The Fare Calculation Module
calculates ticket charges based on travel distance and number of passengers. Additional charges such as
GST are included to determine the final ticket amount accurately.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
IMPLEMENTATION
Search Bus and Ticket Generation Module
The Search Bus Module enables passengers to find buses based on source and destination locations. It
searches through available bus records and displays matching results. The Ticket Generation Module
creates a formatted ticket containing passenger information, bus details, seat number, journey route, and
fare details. This ticket serves as confirmation of successful booking.
Booking History and Menu Driven Module
The Booking History Module maintains records of all previous bookings and allows administrators or
users to review reservation details whenever required. The Menu Driven Module integrates all
functionalities into a single interface, providing options for registration, booking, cancellation, fare
calculation, ticket generation, and history viewing. This improves usability and makes the system user-
friendly.
Dept of CSE,[Link],K.G.F
BUS TICKET BOOKING SYSTEM 2025-2026
Dept of CSE,[Link],K.G.F
BUS TICKET BOOKING SYSTEM 2025-2026
Dept of CSE,[Link],K.G.F
BUS TICKET BOOKING SYSTEM 2025-2026
Dept of CSE,[Link],K.G.F
BUS TICKET BOOKING SYSTEM 2025-2026
Dept of CSE,[Link],K.G.F
BUS TICKET BOOKING SYSTEM 2025-2026
Dept of CSE,[Link],K.G.F
BUS TICKET BOOKING SYSTEM 2025-2026
Dept of CSE,[Link],K.G.F
BUS TICKET BOOKING SYSTEM 2025-2026
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
Conclusion
The Bus Ticket Booking System was successfully designed and implemented using Database Management
System (DBMS) concepts. The project efficiently manages bus details, passenger information, seat
availability, ticket booking, ticket cancellation, fare calculation, and booking records in a systematic
manner. The database ensures accurate storage, retrieval, and management of data while minimizing
redundancy and maintaining data integrity.
Through the implementation of various modules and SQL operations, the system provides a reliable and
user-friendly platform for handling bus reservation activities. The developed system reduces manual
work, improves booking accuracy, prevents duplicate reservations, and enables quick access to passenger
and ticket information. It also enhances data security and simplifies record maintenance through effective
database management techniques.
The successful completion of this project demonstrates the practical application of DBMS concepts such
as tables, queries, relationships, insertion, updating, deletion, and data retrieval. Therefore, the Bus
Ticket Booking System serves as an efficient solution for automating reservation processes and can be
further enhanced with online payment integration, real-time seat tracking, and mobile application
support in future developments.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
REFERENCES
1. Silberschatz, Abraham, Korth, Henry F., and Sudarshan, S., Database
System Concepts, Seventh Edition, McGraw-Hill Education.
2. Elmasri, Ramez and Navathe, Shamkant B., Fundamentals of Database
Systems, Seventh Edition, Pearson Education.
3. Ramakrishnan, Raghu and Gehrke, Johannes, Database Management
Systems, Third Edition, McGraw-Hill Publications.
4. Date, C. J., An Introduction to Database Systems, Eighth Edition, Addison-
Wesley Publications.
5. Coronel, Carlos and Morris, Steven, Database Systems: Design,
Implementation and Management, Cengage Learning.
6. Groff, James R. and Weinberg, Paul N., SQL: The Complete Reference,
McGraw-Hill Education.
7. Pratt, Philip J. and Last, Mary Z., Concepts of Database Management,
Cengage Learning.
Dept of CSE,[Link],K.G.F
 BUS TICKET BOOKING SYSTEM 2025-2026
REFERENCES
8. Rob, Peter and Coronel, Carlos, Database Systems: Design, Implementation
and Management, Thomson Course Technology.
9. Ullman, Jeffrey D. and Widom, Jennifer, A First Course in Database
Systems, Pearson Education.
10. Connolly, Thomas and Begg, Carolyn, Database Systems: A Practical
Approach to Design, Implementation and Management, Pearson Education.
11. Academic references related to relational database management systems,
database design methodologies, normalization techniques, entity relationship
modeling, and structured query language concepts.
12. Reference materials used for understanding database architecture, data
storage techniques, indexing methods, query optimization, and transaction
management mechanisms.
13. Technical literature related to transportation management systems,
reservation systems, passenger information management, and computerized
ticket booking applications.
14. Study materials covering Data Definition Language (DDL), Data
Manipulation Language (DML), joins, constraints, keys, views, and database
security concepts.
Dept of CSE,[Link],K.G.F