In this assignment, you will be asked to go through the data normalization process to take the provided sample un-normalized data and bring it up to the Third Normal Form.
Follow the rules of normalization and show the output of the normalization for each Normal Form i.e. your assignment requires you to show the structure of the tables in each of the Normal Form (from First Normal to Second Normal and finally the Third Normal Form).
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 Custome rID Customer Name Salespers onlD Sales Person Name Contact 11D Contact 1 Contact 1 Phone2 Contact ID Contact 2 Contact 2 Phone Contoso 1 John Doe 1 Mary Jane (518) 456-9791 Selena Duran (518) 299-9999 Hemingway 2 Dollie Wilde 1 2 Robert Down (518) 456 7895 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. 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 Custome rID Customer Name Salespers onlD Sales Person Name Contact 11D Contact 1 Contact 1 Phone2 Contact ID Contact 2 Contact 2 Phone Contoso 1 John Doe 1 Mary Jane (518) 456-9791 Selena Duran (518) 299-9999 Hemingway 2 Dollie Wilde 1 2 Robert Down (518) 456 7895 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
