Vehicle Showroom Database design – The database design for an online vehicle showroom would focus on storing and organizing information about the vehicles available for sale, as well as tracking customer interactions and orders. The database for an online vehicle showroom would typically include the following tables:
- Vehicles: This table would store information about the various vehicles available for sale, such as the make, model, year, price, and specifications. It would also include a field to store images of the vehicles.
- Makes: This table would store information about the different vehicle makes, such as the name and a brief description.
- Models: This table would store information about the different vehicle models, such as the name, make, and a brief description.
- Features: This table would store information about the various features that vehicles may have, such as air conditioning, navigation, and parking sensors.
- Inventory: This table would track the availability of vehicles in real-time, including the quantity in stock and the status (e.g., available, sold, reserved).
- Orders: This table would store information about customer orders, including the customer’s contact information, the vehicle purchased, and the purchase price.
- Customers: This table would store information about the showroom’s customers, including their contact information, purchase history, and any communication or support requests.
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:
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