/LocDB

This is a repository to hold DBMS course project which is a taxi management service simulation using MySQL and JavaScript

Primary LanguageJavaScript

LocDB

A database schema for Taxi Management services.

Project Description:

LocDB - A Taxi management service
With the increasing demand of online services, the taxi booking services have emerged to be one of the primary sectors where databases are employed heavily. Although there is a lot of optimizations and tools being deployed for the major real-life use cases, a simple and basic version of the same design pattern is aimed at by this project. The major focus of LocDB is to simulate a smaller case scenario of a location based reactive system. The basic requirement of the entire project will rely heavily on the database design and the way the data is represented for the needed services. LocDB will provide a similar interface wherein a customer can book taxis that are in a proximity to their current location and create trips to new locations.

ER Diagram

Tech Stack Used:

Programming Languages:
1. JavaScript
2. HTML5.1
3. CSS3
4. SQL 8.0.2.1

Frameworks:
1. MySQL
2. React
3. Express
4. NodeJS
Installation guide:
git clone [repo link]

# Install the dependencies
cd locdb & npm i
cd locdb/backend & npm i

# Run the frontend
npm start

# Run the backend
cd backend
nodemon server.js

Project Features:

The project consists of three interfaces:

  1. Admin
1. Add Drivers
2. View the Garage Status
  1. Customer
1. Can login/register into the system
2. The customer can request for new trips from the home screen
3. The source and destination of the trips can be selected and the nearby taxis will be listed.
4. From the list one taxi can be selected and the driver will be notified about the request.
5. The status of booking can be viewed.
6. Once the driver approves the request then then trip will be started.
7. The trip can be ended by the customer by providing rating and payment details
8. All the trip history of the user can be seen on the home screen.
  1. Driver
1. Can login to the system and view details about location, rating etc.
2. Can update current location from the home screen.
3. The driver can check their shift times and taxi details.
4. All the trip requests to the driver can be seen in requests list.
5. The driver can approve the trip and select fare and duration of the ride.
6. The driver will get rating after completing the trip.