86|EXCEL – Smarty’s School Supplies

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.

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!

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.


This was my solution to the Normalization challenge for Excel:
Oct 23 TechHub Challenge.xlsx (10.1 KB)

Pretty good review of Noramlization!


Challenge86_Data.xlsx (14.3 KB)


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)


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.


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)


Copy of Challenge86_Data.xlsx (14.2 KB)
Here are my tables for the normalization of this data.

1 Like

0606_Skidmore_TechHubTrainingChallange86.xlsx (17.6 KB)


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!

Challenge86_Data_MasonLeSueur.xlsx (12.0 KB)

Here’s my solution to the data normalization challenge.
Challenge86_Data.xlsx (10.6 KB)


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!