The design of Vehicle Showroom database tables are shown below:

Table name: 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

 

Table name: 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

 

Table name: 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.

image

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

 

Table name: IMAGE

Sl.no

Attribute

Data Type

Description

Constraints

1.

imagined

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

 

Table name:  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.

cost

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

 

Table name: 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

 

Table name: 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:

Online Vehicle Showroom er diagram

 

 

DOWNLOAD NOW 🔥3.3 K

FreeStudentProjects

A collection of source codes that I wrote in VB 6.0, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone. for more info please WhatsApp us on +91-9481545735 or Email id: freestudentprojectsindia@gmail.com

10 Comments

  • Neetu Yadav

    May 20, 2016 - 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 neetu.abbey@gmail.com

    • freestudentprojects

      May 20, 2016 - 11:05 PM

      Complete project report uploaded in the project report section. Let me know if you didn’t get that project

    • joe

      October 26, 2016 - 11:00 PM

      you already have the project?

      • Shiva Prasad

        October 31, 2016 - 12:32 AM

        Yes.. source code already published.

    • MUHAMMAD KHALID KHAN

      November 17, 2017 - 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 m.khalidniazi909@gmail.com

  • sammy

    October 6, 2016 - 8:52 PM

    is source code for this project available

    • joe

      October 26, 2016 - 10:59 PM

      you have already the project???

  • joe

    October 26, 2016 - 10:59 PM

    can i have this database please send to my email

  • mutasadiq iqbal

    November 8, 2016 - 5:42 PM

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

  • sammer t

    July 19, 2017 - 7:01 PM

    can i get vehicle showroom management project
    in vb 6.0

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.