Contents

Systematically organized or structured repository of indexed information (usually as a group of linked data files) that allows easy retrieval, updating, analysis, and output of data. Stored usually in a computer, this data could be in the form of graphics, reports, scripts, tables, text, etc., representing almost every kind of information.

Car Dealership

A car dealership or vehicle local distribution is a business that sells new or used cars at the retail level, based on a dealership contract with an automaker or its sales subsidiary. It employs automobile salespeople to sell their automotive vehicles.

Purpose

This database will help car dealers company sells more cars by using tools they need to effectively build relationship with customers. And save the records of all customers.

System overview

The database is created on MYSQL. MySQL will save the company money while allowing the flexibility and scalability needed for dealership grow.

Hardware and software requirements

Hardware

This section describes the minimum hardware requirements for the Enterprise Service Monitor.

2 CPU Cores

2 GB RAM

Disk I/O subsystem applicable to a write-intensive database

Software (Operating System)

Microsoft

Windows XP x86_32, x86_64

Windows 7, 8 ,10 x86_32, x86_64

Apple

Apple macOS 10.12 x86_64

Apple OS X v10.11 x86_64

Apple Mac OS X v10.6 x86_32, x86_64

Data Dictionary

1. Location table

The location table was created to store the location of salesperson of company because company have many branches.

Attributes	Data type	Size	Description
PK. Location_ID	CHAR	4	Assigned identifier with format. I.e. CR.1
Location_Name	VARCHAR	30	Location name i.e. Honda car dealership Rawalpindi

2. Salesperson

Salesperson table is created to store the salesperson information, such as name Id and location. This table linked to the location table.

Attributes	Data type	Size	Description
PK. Salesperson_ID	CHAR	5	Assigned identifier with format. i.e. SP101
FK. Location	CHAR	4	Id for location where employee works.
Name	VARCHAR	15	Name of salesperson

3. Customer

The customer table records all the information of customer.

Attributes	Data type	Size	Description
PK. customer_ID	CHAR	8	Assigned identifier with format. i.e. CUS001
Customer_name	VARCHAR	15	Name of customer
Address	CHAR	40	Address of customer
Phone#	INT	14	Phone number of customer with area code

4. Manufacturer

This table records all the information of manufacturing factory of vehicle.

Attributes	Data type	Size	Description
PK. Manufac_ID	CHAR	5	Manufacturing factory ID i.e. M-F.500
Name	VARCHAR	50	Manufacturing factory name

5. Vehicle

Vehicle table include all the information about vehicle. This is the most important table

Linked with four more tables

Attributes	Data type	Size	Description
PK. Vehicle_ID	CHAR	6	Assigned identifier with format i.e. VIC1.1
Color	VARCHAR	10	Vehicle color i.e. Gray
FK. Manuf_ID	CHAR	5	Manufacturer factory id i.e. M-F.500
FK. Model_ID	CHAR	5	Model of vehicle
Price	INT	--	Vehicle price

6. Model

Model of the vehicle with year include in this table. Linked with vehicle table.

Attributes	Data type	Size	Description
PK. Model_ID	CHAR	5	MODEL id of vehicle i.e. MOD01
Name	VARCHAR	15	Model name
Model_Year	INT	--	Model year of vehicle

7. Insurance policies

This table consists of the information of insurance policy, vehicle information insurance

Company and policy start date.

Attributes	Data type	Size	Description
PK. Policy_ID	CHAR	5	Insurance policy id i.e. IP101
FK. Vehicle_ID	CHAR	6	Vehicle id
FK. Insurance_company_ID	CHAR	4	Insurance company id
Policy_start_date	DATE	--	Starting date of insurance policy

8. Insurance company

This table include the company information and linked with insurance policy table.

Attributes	Data type	Size	Description
PK. Insur_comp_ID	CHAR	4	Assign identifier with format i.e. IC01
Name	VARCHAR	30	Name of insurance company

9. Deal

This is the main and important table of database. The table include the information related to deal of vehicle and Linked with three tables.

Attributes	Data type	Size	Description
PK. Deal_ID	CHAR	8	Assigned identifier with format i.e. Deal-001
FK. Customer_ID	CHAR	5	(Customer id) linked with customer table
FK. Vehicle_ID	CHAR	6	(Vehicle id) linked with vehicle table
FK. Salesperson_ID	CHAR	5	(Salesperson id) linked with salesperson table
Agreed_price	INT	--	Final price of vehicle which is agreed by customer and salesperson
Dealing_date	Date	--	Dealing date of vehicle

10. Customer visit

This table records the information of customer visit in company because dealership company also responsible for vehicle maintenance.

Attributes	Data type	Size	Description
PK. Custm_visit_ID	CHAR	5	Assigned identifier with format i.e. 1.VIS
FK. Customer_ID	CHAR	5	Customer id
FK. Salesperson_ID	CHAR	5	Salesperson id
Visiting_date	DATE	--	Visiting date of customer