Git Product home page Git Product logo

car_rental_system's Introduction

Car_Rental_System

It is DBMS based project where cars is listed by the Owners and Customers can take the listed cars on rent. The technology used in this project is Java for the interface and MySQL for the database. The database includes four tables:

  1. Owner Table: It stores all the information regarding the owner such as Owner ID, Owner Name, Address, Email, Password and Joining Date.
  2. Customer Table: It stores all the information regarding the customer such as Customer ID, Customer Name, Driving License, Address, Email and Password.
  3. Vehicle: It stores all the details of the vehicles registered by the owner such as Vehicle ID, Owner ID, Model, Plate No, Mileage, Rent Price, Condition and Reservation.
  4. Reservation_details Table: It stores the information regarding which customer has booked which vehicle such as Reserve ID, Vehicle ID, Customer ID, Rental Date, Pickup Date, Return Date, Number of Days and Pickup Place.

Note: It does not includes any fuctionalities regarding payement or billing system. So in future it is hoped that it will be implemented.

ER Diagram

image

How to Install and Run the Project

First fork the repository in your local machine. Before running any file you have to do certain changes to run into your machine. Enter your MySQL password at root="Your_MySQL_Password" is present.

image

Run the code present in sql file either in MySQL client or Workbench. Now you're ready to run the project. Run the Java file.

car_rental_system's People

Contributors

perin-mangukiya avatar

Watchers

 avatar

Forkers

raashil

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.