Taxi Management System

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

Features:

• 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.

Technical Details:

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

Requirements:

• NodeJS
• MySQL
• Below DataBase Structure

Database:

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

Database Schema:

• user:
  

• driver:
  

• admin:
  

• taxi:
  

• trip:
  

Dependencies:

• express
• mysql
• nodemon

How to Run:

• cd <root_directory>
• npm install
• npm start
• Click on the link to open the application: http://localhost:1412/

Application Pages:

• 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/

Our APIs:

• 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