The design of Vehicle Showroom database tables are shown below:
Download Vehicle Showroom Database design:
Tablename : admin
| Sl.no |
Attribute |
Data Type |
Description |
Constraints |
| 1. |
adminid |
int(10) |
Administrator id |
Primary key |
| 2. |
adminname |
varchar(25) |
Administrator name |
| 3. |
username |
varchar(25) |
User name |
| 4. |
password |
varchar(25) |
Password |
| 5. |
contactnumber |
varchar(25) |
Phone number |
| 6. |
createdat |
date |
Created time |
| 7. |
lastlogin |
datetime |
Last login time |
| 8. |
status |
varchar(10) |
status |
Tablename: customer
| Sl.no |
Attribute |
Data Type |
Description |
Constraints |
| 1. |
custid |
int(10) |
Customerid |
Primary key |
| 2. |
fname |
varchar(25) |
First name |
| 3. |
lname |
varchar(25) |
Last name |
| 4. |
contactno |
varchar(25) |
Phone number |
| 5. |
emailid |
varchar(25) |
Email id |
| 6. |
password |
varchar(25) |
Password |
| 7. |
address |
text |
Address |
| 8. |
city |
varchar(20) |
City |
| 9. |
state |
varchar(20) |
Status |
| 10. |
country |
varchar(50) |
Country |
| 11. |
pincode |
varchar(10) |
Pincode |
| 12. |
gender |
varchar(10) |
Gender |
| 13. |
createdat |
date |
Created time |
| 14. |
lastlogin |
datetime |
Last login time |
| 15. |
status |
varchar(10) |
Status |
Tablename: dealer
| Sl.no |
Attribute |
Data Type |
Description |
Constraints |
| 1. |
dealerid |
int(10) |
Dealer id |
Primary key |
| 2. |
adminid |
int(10) |
Administrator id |
Foreign key |
| 3. |
companyname |
varchar(25) |
Company name |
| 4. |
imgid |
int(10) |
Image id |
| 5. |
fname |
varchar(25) |
Fisrt name |
| 6. |
lname |
varchar(25) |
Last name |
| 7. |
username |
varchar(25) |
User name |
| 8. |
password |
varchar(25) |
Password |
| 9. |
contactnumber |
varchar(15) |
Phone number |
| 10. |
address |
text |
Address |
| 11. |
createdat |
date |
Created time |
| 12. |
lastlogin |
datetime |
Last login time |
| 13. |
status |
varchar(10) |
Status |
Tablename: image
| Sl.no |
Attribute |
Data Type |
Description |
Constraints |
| 1. |
imgid |
int(10) |
Image id |
Primary key |
| 2. |
imagename |
varchar(25) |
Imagename |
| 3. |
vehid |
int(10) |
Vehicle id |
Foreign key |
| 4. |
imagepath |
varchar(50) |
Image path |
| 5. |
defaultimg |
int(1) |
Default image |
Tablename: sales
| Sl.no |
Attribute |
Data Type |
Description |
Constraints |
| 1. |
salesid |
int(10) |
Sales id |
Primary key |
| 2. |
vehid |
int(10) |
Vehicle id |
Foreign key |
| 3. |
custid |
int(10) |
Customer id |
Foreign key |
| 4. |
showroomid |
int(10) |
Showroom id |
Foreign key |
| 5. |
vehcost |
float(10,2) |
Vehicle cost |
| 6. |
taxid |
int(10) |
Tax id |
Foreign key |
| 7. |
ord_date |
date |
Ordered date |
| 8. |
del_date |
date |
Delivery date |
| 9. |
description |
text |
Description of vehicle |
| 10. |
status |
varchar(10) |
Status |
Table name: showroom
| Sl.no |
Attribute |
Data Type |
Description |
Constraints |
| 1. |
showroomid |
int(10) |
Showroom id |
Primary key |
| 2. |
dealerid |
int(10) |
Dealer id |
Foreign key |
| 3. |
showroomname |
varchar(50) |
Showroom name |
| 4. |
imagepath |
varchar(100) |
Image path |
| 5. |
contactno |
varchar(15) |
Contact number |
| 6. |
address |
text |
Address |
| 7. |
city |
varchar(25) |
City |
| 8. |
state |
varchar(25) |
Status |
| 9. |
pincode |
varchar(10) |
Pincode |
| 10. |
status |
varchar(10) |
Status |
Tablename: tax
| Sl.no |
Attribute |
Data Type |
Description |
Constraints |
| 1. |
taxid |
int(10) |
Tax id |
Primary key |
| 2. |
taxdescription |
text |
Tax description |
| 3. |
tax |
float(10,2) |
Total Tax |
| 4. |
status |
varchar(10) |
Status |
TABLENAME: vehicle
| Sl.no |
Attribute |
Data Type |
Description |
Constraints |
| 1. |
vehid |
int(10) |
Vehicle id |
Primary key |
| 2. |
dealerid |
int(10) |
Dealer id |
Foreign key |
| 3. |
vehname |
varchar(50) |
Vehicle name |
| 4. |
vehmodel |
varchar(50) |
Vehicle model |
| 5. |
vehtype |
varchar(15) |
Vehicle type |
| 6. |
vehdescription |
text |
Vehicle description |
| 7. |
vehcost |
decimal(10,2) |
Vehicle cost |
| 8. |
createdat |
date |
Create time |
| 9. |
status |
varchar(10) |
status |
Vehicle Showroom ER diagram:
Can i get the complete project report for this Online Vehicle Showroom along with some forms and reports?
My emial id is [email protected]
Complete project report uploaded in the project report section. Let me know if you didn’t get that project
you already have the project?
Yes.. source code already published.
can u send me whole project report of Online vehicle showroom …..name of Entities Name of Attributes and EERD
send me on my email [email protected]
is source code for this project available
you have already the project???
can i have this database please send to my email
Where i can download online vehicle management system with source code coding
can i get vehicle showroom management project
in vb 6.0