Taxi Booking System Database Design
Year:
2023
Overview
This project, completed as part of DS5110 - Introduction to Data Management and Processing, focuses on developing a comprehensive Taxi/Cab Booking System that streamlines ride-hailing and management processes. The system connects passengers with available drivers, ensuring convenience, transparency, and efficient service delivery. It was designed to address the core challenges of a modern transportation service-user management, trip scheduling, billing, and feedback while maintaining data integrity and scalability.
Approach
The system was built around a relational database model comprising fourteen normalized tables, representing key components such as Users, Drivers, Trips, Vehicles, Payments, and Ratings.
A strong emphasis was placed on data consistency, referential integrity, and normalization to eliminate redundancy and enhance query performance. The project followed a modular design approach, integrating multiple components such as trip management, surge pricing, and promotions into a cohesive data architecture. Team collaboration and iterative design ensured alignment with the real-world operational needs of ride-hailing platforms.
Key Features
Comprehensive Schema Design: Developed 14 interlinked database tables covering all core operations-users, trips, vehicles, and payments.
Data Normalization: Ensured consistency, minimized redundancy, and improved query efficiency.
Integrated Functional Modules: Included payment and billing, rating and feedback, and promotions with surge pricing.
User & Driver Management: Enabled robust user registration, authentication, and driver allocation mechanisms.
Scalability and Reliability: Designed a scalable schema supporting efficient data handling for growing user bases.
