Specialty Imports – Database Normalization

Student Name
Student ID 1
Specialty Imports – Database Normalization
Submitted By
Course
Professor
Date

Student Name
Student ID 2
Introduction
Specialty Imports is a vehicle dealership which is situated on the "auto strip" in the area of
North-West Brampton where few other dealerships are situated as Brampton is right now moving
numerous dealerships into one central location. Specialty Imports has a conventional dealership
authoritative structure. The parts as well as service manager is like a business that operates inside
a business and has not been firmly administered. Accounts manager is fundamentally responsible
of records receivable and different parts of revenue. Most administration work is charged on
bank cards and this processing on papers is processed very quickly.
After the client and businessperson agrees on the deal, the sales invoice is made and signed by
both the purchaser and salesman. The main concern of the owner is to monitor existing and
potential clients, the vehicles that they look for, the vehicles he has in stock and that they have
obtained. An on-line on request framework that can display the name, address and phone number
of forthcoming clients who have shown their enthusiasm for chosen vehicles. The scan criteria
for finding such clients would incorporate integration of make, model name, color, upholstery
style and year of make of their favored vehicles. He has discovered that a few clients will think
about a few possible vehicles, so various inclinations must be dealt with. In this report, we will
normalize the forms that are provided. All the entities which we have considered for
implementing database for the organization will be in Third Normal Form.
Planning & Analysis
Executing database undertaking will give specialists the tool to manage their customer bases in
an efficient way and to upgrade the sales process of the association, and can help to give better
advertising systems. Implementing database can help to lessen the redundancy of information.

Student Name
Student ID 3
Executing database can upgrade efficiency, reduce costs, and improve vehicle sales over
different locations in Brampton. As opposed to each dealership area being an island onto itself,
there will be one centralized database that has a place with the Specialty Imports so the critical
information can be shared among with other dealers. Any business administrator or manager can
investigate a customer and see their history, including which vehicle they have requested, which
sales man they chatted with, and what they require in a vehicle.
Maurice will have the ability to successfully make sense of which salesman each customer has a
place with, and which agents should get advantage for an explicit arrangement, facilitating the
contentions among sales agents and it decreases staff turnover. Transferring information to the
database will get the precise outcome about specific client following and that will give business
people and directors the information they bring to sell more vehicles. It must be possible if a
specific procedure is actualized for the usage of database. (Rothaar, 2014).
Normalization
When building up the outline of a relational database, a standout amongst the most vital aspect to
be considered is to guarantee that the duplication is limited. Normalization is the way toward
organizing the information in the database. Normalization is most important which is utilized to
limit the redundancy from a connection or set of relations. It is likewise used to minimize the
unwanted attributes like Insertion, Update and Deletion Anomalies. The center idea of database
normalization is to isolate the tables into small sub-tables and store pointers to information as
opposed to repeating it. Without Normalization, it is hard to deal with and update database,
without confronting information loss. Insertion, Updation and Deletion anomalies are extremely
frequent if Database isn't normalized. (Goel, 2018).