StudentProjects.Live September 13, 2014

Vehicle Showroom Database design

StudentProjects.Live September 13, 2014
Online Vehicle Showroom er diagram

The design of Vehicle Showroom database tables are shown below:

Download Vehicle Showroom Database design:

download

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:

Online Vehicle Showroom er diagram

StudentProjects.Live

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.

Related Posts

Subscribe
Notify of
guest

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

10 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Neetu Yadav
Neetu Yadav
5 years ago

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

0
Reply
freestudentprojects
freestudentprojects
5 years ago
Reply to  Neetu Yadav

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

0
Reply
joe
joe
4 years ago
Reply to  Neetu Yadav

you already have the project?

0
Reply
StudentProjects.Live
Author
StudentProjects.Live
4 years ago
Reply to  joe

Yes.. source code already published.

0
Reply
MUHAMMAD KHALID KHAN
MUHAMMAD KHALID KHAN
3 years ago
Reply to  Neetu Yadav

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]

0
Reply
sammy
sammy
4 years ago

is source code for this project available

0
Reply
joe
joe
4 years ago
Reply to  sammy

you have already the project???

0
Reply
joe
joe
4 years ago

can i have this database please send to my email

0
Reply
mutasadiq iqbal
mutasadiq iqbal
4 years ago

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

0
Reply
sammer t
sammer t
3 years ago

can i get vehicle showroom management project
in vb 6.0

0
Reply