Vehicle Showroom Database design

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:

10 thoughts on “Vehicle Showroom Database design”

sammer t says:

July 19, 2017 at 7:01 PM

can i get vehicle showroom management project
in vb 6.0

mutasadiq iqbal says:

November 8, 2016 at 5:42 PM

Where i can download online vehicle management system with source code coding

joe says:

October 26, 2016 at 10:59 PM

can i have this database please send to my email

sammy says:

October 6, 2016 at 8:52 PM

is source code for this project available

1. joe says:
  
  October 26, 2016 at 10:59 PM
  
  you have already the project???
  
Neetu Yadav says:

May 20, 2016 at 9:58 AM

Can i get the complete project report for this Online Vehicle Showroom along with some forms and reports?
My emial id is [email protected]

1. freestudentprojects says:
  
  May 20, 2016 at 11:05 PM
  
  Complete project report uploaded in the project report section. Let me know if you didn’t get that project
  
2. joe says:
  
  October 26, 2016 at 11:00 PM
  
  you already have the project?
  
  1. StudentProjects.Live says:
    
    October 31, 2016 at 12:32 AM
    
    Yes.. source code already published.
    
3. MUHAMMAD KHALID KHAN says:
  
  November 17, 2017 at 6:39 PM
  
  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]

Vehicle Showroom Database design:

Tablename: customer

Tablename: dealer

Tablename: image

Tablename: sales

Table name: showroom

TABLENAME: vehicle

Vehicle Showroom ER diagram:

Related Projects

Database Tables of Supermarket Management System

Hostel Management System in PHP (PHP: Hypertext Preprocessor)

Table Design of College Social Network

10 thoughts on “Vehicle Showroom Database design”

Leave a Reply Cancel reply

New Posts

Online Auction and Bidding System

Grocery Store Management System – Mini Project

College Voting System In VB.Net

Temple Management System