Challenge86_Data.xlsx (14.4 KB)
Here’s every in 3NF!
Challenge86_Data.xlsx (11.0 KB)
Primary keys highlighted
Here is my solution to putting the data into 3NF!
I identified my PKs in the flat file to be a concatenated Primary key of Invoice Number and Invoice Item Number. The pictures attached ID my primary key for each table highlighted in yellow and the foreign keys are labeled with parentheses.
1 Like
86_Jace Harrick.xlsx (12.6 KB)
Here is my solution!
Challenge86_JaredMerrill.xlsx (16.3 KB)
Pretty straightforward, you just have to remember that there should be a table for every different type of ID# and then in this case one more to explain the transaction (details of the invoice)
This was a great normalization practice. Here are my four ending tables with the primary keys highlighted.
Challenge86_Data_MTAYLORSOLUTION.xlsx (14.5 KB)
Loved this one! Good review of Normalization and TEXTBEFORE and TEXTAFTER
Here is my solution!
Challenge86_Mckay_Abbott_Solution.xlsx (10.2 KB)
1 Like
Challenge86_Data.xlsx (11.7 KB)
Here’s my Database!
Great challenge Boston! I tried to use the TEXTBEFORE and TEXTAFTER functions in excel to split up the address. I ended up using text to columns for the City and State but if anyone knows of a function I could use, please let me know.
1 Like
Challenge86_Data.xlsx (14.2 KB)
Here is my solution to the problem!
Dylan I love this!
Challenge86_Data.xlsx (12.9 KB)
This was a good refresher!
Challenge86_Angle.xlsx (14.1 KB)
This was great practice!
Challenge86_Data-Megan Broadbent.xlsx (15.5 KB)
Challenge86_Data.xlsx (14.0 KB)
Here is my solution!
Challenge86_Data.xlsx (10.5 KB)
Challenge86_Data.xlsx (14.2 KB)
Challenge86_Data.xlsx (14.2 KB)