Problem Statement: Hank$$s Car Dealership Here is a tabular view of the un$-$normalized data

$\backslash$table$[[\backslash$table$[[$Custome$],[$rID$]],\backslash$table$[[$Customer$],[$Name$]],\backslash$table$[[$Salespers$],[$onID$]],\backslash$table$[[$SalesPerson$],[$Name$]],\backslash$table$[[$Contact$],[1$ ID$]],$Contact $1,\backslash$table$[[$Contact $1],[$Phone$]],\backslash$table$[[$Contact$],[2$ ID$]],$Contact $2,\backslash$table$[[$Contact $2],[$Phone$]]],[1,$Contoso,$1,$John Doe,$1,\backslash$table$[[$Mary$],[$Jane$]],\backslash$table$[[\backslash$table$[[(518)],[456-9791]]]],2,\backslash$table$[[$Selena$],[$Duran$]],\backslash$table$[[\backslash$table$[[(518)],[299-9999]]]]]]$

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)4567896$

$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 Sheet

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

Note:

You can choose to create your table structure for First Normal Form in Google Sheets by downloading a copy of the Google Sheet data template and submitting it as part of your assignment $2$ submission. The brief overview needs to be entered in this document.

Brief Rationale

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

Note:

You can choose to create your table structure for Second Normal Form in Google Sheets by downloading a copy of the Google Sheet data template and submitting it as part of your assignment $2$ submission. The brief overview needs to be entered in this document.

Brief Rationale

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

Note:

You can choose to create your table structure for Third Normal Form in Google Sheets by downloading a copy of the Google Sheet data template and submitting it as part of your assignment $2$ submission. The brief overview needs to be entered in this document.

Brief Rationale