A PBL (Project Based Learning) project for the course DBE (Database Engineering) at Kolhapur Institute of Technology.
A simple Taxi Management System.

Table of Contents

• Features
• User Interface
  • Home Screen
  • Registration
    • User Registration
    • Driver Registration
  • Login
    • Admin Login
    • User-Driver Login
  • Dashboard
    • Admin Dasboard
    • User Dashboard
    • Driver Dashboard
• Technical Details
• Requirements
• Database
• Database Schema
• Dependencies
• How to Run
• Application Pages
• Our APIs

• User and Driver Registration.
• User can book a trip and Driver can accept the booking.
• User and Driver can view his/her booked/accepted trips.
• Driver can view the available trips along with the distance and fare.
• User can see the Driver's details when he/she accepts the booking.

User Registration

Driver Registration

Login

Admin Login

User-Driver Login

Admin Dasboard

User Dashboard

Driver Dashboard

• Frontend: Bootstrap, HTML, CSS, JavaScript
• Backend: NodeJS, ExpressJS
• Database: MySQL

• NodeJS
• MySQL
• Below DataBase Structure

• Name: taxi_management_system
• Tables:
  • user
  • driver
  • admin
  • taxi
  • trip

• user:
  

• driver:
  

• admin:
  

• taxi:
  

• trip:
  

• express
• mysql
• nodemon

• cd <root_directory>

npm install
npm start

• Click on the link to open the application: http://localhost:1412/

• Home Page: http://localhost:1412/
• User Registration Page: http://localhost:1412/signup-user/
• Driver Registration Page: http://localhost:1412/signup-driver/
• Login Page: http://localhost:1412/login/
• User Dashboard Page: http://localhost:1412/user/
• Driver Dashboard Page: http://localhost:1412/driver/
• Admin Login Page: http://localhost:1412/admin-login/
• Admin Dashboard Page: http://localhost:1412/admin/

• Registration:

  • User: /api/registration/user
  • Driver: /api/registration/driver

• Login: /api/login/:role

• Session-End: /api/session-end/:role

• Credentials: /api/credentials/:role

• Admin Queries:

  • User: /api/query/user
  • Driver: /api/query/driver
  • Trip: /api/query/trip
  • Custom: /api/query/custom

• Trip:

  • Booking: /api/trip/booking
  • History: /api/trip/history/:role
  • Accepting: /api/trip/accepting
  • Available: /api/trip/available