/Car-Rental-and-Pooling-System

DBMS Project

Primary LanguageEJS

Car-Rental-and-Pooling-System

Car rental and pooling web app with authentication, membership, car management, bookings, billing, maintenance, pooling, and ratings. Ensured data consistency and trigger-based updates. Admin access for maintenance and billing. Advanced billing calculations with member discounts. Efficient and user-friendly car rental system.

ER Diagram image

Full Report

Steps to start server

  1. Install PostgreSQL 12.x (https://www.postgresql.org/)

  2. Inside ./data/database.js, set the host, password, database, and port according to your runtime environment.

  3. Please make sure that database have relational model as given in er-diagram.png. Inside ./sql-queries you will find all psql queries to create database with required relational model.

  4. Install Node.js based on your operating system. Visit the website (https://nodejs.org) and download the LTS version 19.9.x of Node.js along with version 9.6.x of npm.

  5. Install all required dependencies

     npm install

  6. start server using following in dev mode

     npm start

  7. To close server

     ./close.sh