Car-Rental-Java-DBMS-Project
Car-Rental-Java-DBMS-Project copied to clipboard
afrozchakure
This is a Car Rental App made in Netbeans using Java and Mysql
Car-Rental-Java-DBMS-Project
- This is a Car Rental App made in Netbeans using Java and Mysql
- For using the project fork the project and clone it in your local repository.
- Open the project in Netbeans IDE.
1. Fork the Repository.
2. Clone the Repository.
git clone https://github.com/afrozchakure/Car-Rental-Java-DBMS-Project.git
The tables included in the MySQL database are:
- carregistration.
- customer.
- rental.
- login.
- returncar.
The name of the database is "rentcar" and the description of tables is given below :
1. "carregistration" table includes :
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | NULL | auto_increment |
| car_no | varchar(255) | YES | NULL | ||
| make | varchar(255) | YES | NULL | ||
| model | varchar(255) | YES | NULL | ||
| available | varchar(255) | YES | NULL |
2. "customer" table includes :
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | NULL | auto_increment |
| cust_id | varchar(255) | YES | NULL | ||
| name | varchar(255) | YES | NULL | ||
| address | tinytext | YES | NULL | ||
| mobile | int(13) | YES | NULL |
3. "rental" table includes :
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | NULL | auto_increment |
| car_id | varchar(255) | YES | NULL | ||
| cust_id | varchar(255) | YES | NULL | ||
| fee | int(11) | YES | NULL | ||
| date | varchar(255) | YES | NULL | ||
| due | varchar(255) | YES | NULL |
4. "login" table includes :
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| login_id | int(11) | NO | PRI | NULL | auto_increment |
| username | varchar(255) | YES | NULL | ||
| password | varchar(255) | YES | NULL |
5. "returncar" table includes :
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | NULL | auto_increment |
| carid | varchar(255) | YES | NULL | ||
| custid | varchar(255) | YES | NULL | ||
| return_date | varchar(255) | YES | NULL | ||
| elap | int(11) | YES | NULL | ||
| fine | int(11) | YES | NULL |
- This repository is open to contributions :smile:. Feel free to raise issues and contribute.
Metadata
17
Stars
26
Forks
Watchers
Owner
afrozchakure
Metadata
This is a Car Rental App made in Netbeans using Java and Mysql