Explain the rationale behind the normalization process for each Normal Form in a brief 1-2 sentences on why the choice was made.

Sample Un-Normalized Data

Problem Statement: Hank’s Car Dealership

Imagine a local auto dealership business located in Albany, New York , owned and operated by a franchise owner named “Hank”. Hank employs salespeople who are responsible for selling used cars to prospective corporate customers who come to Hank’s small dealership shop for renting cars for company trips. Hank has requested you to build a small Car Dealership database where he wants to maintain and store information about his prospective corporate customers, their contacts and his salespeople.

Since Hank is not an IT guy, he has started with a simple approach of a sample un-normalized table writing it on a piece of paper with attributes and sample rows of data.

Here is a tabular view of the un-normalized data

Customer ID	Customer Name	SalespersonID	SalesPerson Name	Contact 1 ID	Contact 1	Contact 1 Phone	Contact 2 ID	Contact 2	Contact 2 Phone
1	Contoso	1	John Doe	1	Mary Jane	(518) 456-9791	2	Selena Duran	(518) 299-9999
2	Hemingway	2	Dollie Wilde	1	Robert Down	(518) 456 7896	2	Lance Wilder	(518) 200-1111

In order to make this assignment more intuitive, I am also attaching a Google Sheets version of the sample data, so that students can choose to create the normalized tables in Google Sheets and create separate tables for each Normal Form.

	Hank's Dealership Un-Normalized table
	Customer ID	Customer Name	SalespersonID	SalesPerson Name	Contact 1 ID	Contact 1	Contact 1 Phone	Contact 2 ID	Contact 2	Contact 2 Phone
	1	Contoso	1	John Doe	1	Mary Jane	(518) 456-9791	2	Selena Duran	(518) 299-9999
	2	Hemingway	2	Dollie Wilde	1	Robert Down	(518) 456 7896	2	Lance Wilder	(518) 200-1111
	First Normal Form (Create your normalized 1NF tables below)
	Second Normal Form (Create your normalized 2NF tables below)

Complete the normalization process and paste the Normalized forms along with a brief overview of the rationale behind each of the Normal Forms.

First Normal Form

Paste your First Normal Form table structure and write a brief overview of your rationale on why this was your choice for First Normal Form

Second Normal Form

Paste your Second Normal Form table structure and write a brief overview of your rationale on why this was your choice for First Normal Form

Third Normal Form

Paste your Third Normal Form table structure and write a brief overview of your rationale on why this was your choice for First Normal Form

Answer rating: 100% (QA)

First Normal Form 1NF Table Structure Table Customers CustomerID CustomerName SalespersonID Salesper... View the full answer