BYU Student Author: @Boston
Reviewers: @DylanKing, @TylerBooth, @Christian
Estimated Time to Solve: 25 Minutes
We provide the solution to this challenge using:
Need a program? Click here.
Overview
You are a junior associate at Smarty’s School Supplies that offers bulk supplies ordering. Smarty’s has an audit scheduled next week and the auditor has asked that the databases be in tip top shape when he arrives! This means that all of the databases in Smarty’s system should be in third normal form. Your boss has tasked you with a portion of invoices from the month of September and has asked you find a way to convert the dataset into smaller tables that can easily reference each other. Good luck!
Instructions
First open the data file and determine what the “key” should be for each table; or in other words, what can uniquely identify each row of data. There should not be any repeat values as primary keys except for the master transaction file which should reference other tables. Make sure to split up the customer first and last name into two separate columns as well as the different parts of the address.
Data Files
Suggestions and Hints
Try splitting the data into four separate groups: Customer, Product, Invoice, and Invoice Item (the master transaction file). Text-to-column can help split the data.
Solution
This was my solution to the Normalization challenge for Excel:
Oct 23 TechHub Challenge.xlsx (10.1 KB)
Pretty good review of Noramlization!
8 Likes
Here is my relational database!
Challenge86_Data.xlsx (12.6 KB)
Challenge86_Data.xlsx (10.2 KB)
Here is my solution!
Challenge86_Data.xlsx (10.5 KB)
Here is what I did!
Challenge86_Data.xlsx (10.2 KB)
This was great normalization practice!
1 Like
Here is my normalized data! This was a great review of normalization and helped me practice the text-to-column technique.
Challenge86-ExcelNormalization.xlsx (10.9 KB)
2 Likes
Here is my data
Challenge86_Data.xlsx (10.9 KB)
Challenge86_Data.xlsx (14.2 KB)
Here is my solution! It was really nice to do this on my own to remind me of what we learned in class today.
3 Likes
The primary key for the first table is both invoice number and invoice item number concatenated.
Then I have three additional tables with the primary keys of: invoice number, product number, and customer number.
Challenge86_Data.xlsx (12.2 KB)
3 Likes
Copy of Challenge86_Data.xlsx (14.2 KB)
Here are my tables for the normalization of this data.
1 Like
Challenge86_Data.xlsx (14.1 KB)
Great practice for third normal form!
1 Like
This is my solution to this normalization challenge!
Challenge86_Data.xlsx (10.3 KB)
-Maren Bayles
Hallie_Anderson_Challenge86_Data_0204.xlsx (11.1 KB)
This was a great way to practice data normalization and help me practice how to separate columns like what we learned in class!
1 Like
Here’s my solution to the data normalization challenge.
Challenge86_Data.xlsx (10.6 KB)
2 Likes
Challenge86_Data_JulianneG.xlsx (10.6 KB)
Here is my file ^. This was helpful to reviewing normalizing data!
Challenge75_Data.xlsx (11.6 KB)
Good practice of normalizing data. Definitely a good refresher!