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 |
Comments ( 10 )
Can i get the complete project report for this Online Vehicle Showroom along with some forms and reports?
My emial id is [email protected]
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]
you already have the project?
Yes.. source code already published.
Complete project report uploaded in the project report section. Let me know if you didn’t get that project
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