Online Auto Booking Service BCS402
CHAPTER 1
ABSTRACT
The Online Auto Driving System is a web-based platform designed to streamline the process of
learning how to drive or hiring professional drivers. It connects users with certified driving
instructors or drivers and allows for real-time scheduling, booking, and payment processing. The
system enhances user convenience by offering features such as driver profiles, vehicle details,
available time slots, and online payments, thereby eliminating the need for manual coordination.
This system primarily consists of modules for user registration, driver management, vehicle
assignment, booking management, and secure payment integration. It benefits both users and
driving service providers by automating key operations and offering transparency in scheduling
and transaction tracking.
The platform ensures a seamless and user-friendly interface, real-time updates, and data integrity
through a well-structured database and a robust backend. The proposed solution aims to digitize
and modernize the traditional driving service experience while ensuring efficiency, accessibility,
and reliability.
DEPT OF ISE KIT, TIPTUR Page 1
Online Auto Booking Service BCS402
CHAPTER 2
INTRODUCTION
Project Overview
The Online Auto Booking Service is a web-based platform designed to simplify the process of
booking auto-rickshaws for daily commuters. With rising urban population and traffic
congestion, traditional methods of hiring autos become time-consuming and inefficient. This
project aims to digitalize the auto-rickshaw booking process, allowing users to request rides
online and get matched with nearby drivers.
Problem Statement
Passengers often face difficulties locating autos during peak hours or in remote locations. There
is also no standardized fare, and waiting times can be long. Drivers, on the other hand, waste fuel
and time roaming in search of passengers. This system seeks to bridge that gap with a centralized
online solution.
DEPT OF ISE KIT, TIPTUR Page 2
Online Auto Booking Service BCS402
CHAPTER 3
METHODOLOGY
Introduction to Managing and Manipulating Booking Records in SQL
Databases
In the context of urban transportation, managing booking records effectively is vital for
delivering timely and efficient services. The Online Auto Booking Service uses Structured Query
Language (SQL) within a Relational Database Management System (RDBMS), such as MySQL,
to store, query, and manage real-time data related to users, drivers, bookings, and administrative
controls. SQL enables robust data manipulation while ensuring the system maintains integrity,
consistency, and performance at scale.
Overview of SQL and Relational Databases
SQL is a powerful and widely adopted language designed to manage data in relational databases.
Relational databases structure data into tables, each comprising rows (records) and columns
(fields). These tables represent various entities in the booking system, such as Users, Drivers,
Bookings, and Admins.
Using primary keys and foreign keys, relationships between these entities are precisely defined,
allowing seamless integration and querying of linked data. This facilitates complex operations
like ride assignments, fare calculation, and user-driver matching while keeping the database
normalized and scalable.
DEPT OF ISE KIT, TIPTUR Page 3
Online Auto Booking Service BCS402
Designing the Auto Management Database
A well-structured database design is crucial for managing the operations of an auto
booking service. Below are the key entities and their roles:
1) Users Table
Stores information about customers using the service.
user_id (Primary Key)
name
email
phone
password
2) Drivers Table
Contains registered drivers and their operational status.
driver_id (Primary Key)
name
license_no
phone
availability (Boolean indicating if driver is available)
3) Bookings Table
Manages booking transactions between users and drivers.
booking_id (Primary Key)
user_id (Foreign Key referencing Users)
driver_id (Foreign Key referencing Drivers)
pickup_location
drop_location
fare
status (e.g., pending, confirmed, completed)
DEPT OF ISE KIT, TIPTUR Page 4
Online Auto Booking Service BCS402
booking_date
4) Admin Table
Handles admin-level login and access control.
admin_id (Primary Key)
username
password
Ensuring Data Integrity and Relationships
To guarantee consistency and prevent data anomalies, the system enforces strict relational
principles:
Primary Keys: Each table uses a primary key to uniquely identify every record, ensuring
data uniqueness and quick access.
Foreign Keys: Used in the Bookings table to link Users and Drivers with appropriate
booking entries, maintaining referential integrity.
Constraints:
o NOT NULL to avoid incomplete entries (e.g., bookings without users).
o CHECK constraints for data validation (e.g., fare > 0).
o UNIQUE constraints for fields like email or license numbers.
SQL Operations in the System
SQL commands used across the system include:
INSERT for creating new users, bookings, and drivers.
SELECT for retrieving available drivers, ride status, and booking history.
UPDATE for modifying driver availability or ride status.
DELETE for removing old or canceled bookings.
DEPT OF ISE KIT, TIPTUR Page 5
Online Auto Booking Service BCS402
CHAPTER 4
RESULT ANALYSIS
Flowcharts and Diagrams
Data Flow Diagram (DFD Level 0)
User --> Book Auto --> Booking System --> Assign --> Driver
User <-- View Ride Status <-- Booking System
Use Case Diagram (Key Actors)
Actors: User, Driver, Admin
Use Cases: Book Ride, Accept Ride, Manage System
DEPT OF ISE KIT, TIPTUR Page 6
Online Auto Booking Service BCS402
Key Features Implemented
1. User Features:
• Secure login/registration
• Instant booking
• Location-based fare estimation
• Ride tracking and cancellation
2. Driver Features:
• Dashboard to manage bookings
• Accept or reject requests
• Status update post-ride
3. Admin Features:
• User/driver control panel
• Booking logs and history
• Report and revenue generation
DEPT OF ISE KIT, TIPTUR Page 7
Online Auto Booking Service BCS402
CHAPTER 5
CONCLUSION
The Online Auto Booking Service provides a practical, scalable, and efficient system for urban
mobility.
By integrating modern web technologies and user-friendly interfaces, the project demonstrates
how digital systems can solve traditional urban commuting challenges.
It simplifies travel for users and creates more ride opportunities for drivers, fostering a win-win
environment.
DEPT OF ISE KIT, TIPTUR Page 8
Online Auto Booking Service BCS402
REFERENCES
Oracle Java Docs - https://docs.oracle.com/en/java/
MySQL Official Docs - https://dev.mysql.com/doc/
Apache Tomcat Server - https://tomcat.apache.org/
JSP & Servlets Tutorials - https://www.javatpoint.com/servlet-tutorial
DEPT OF ISE KIT, TIPTUR Page 9
