Join Adam Wilbert for an in-depth discussion in this video Solution: Normalizing a dataset, part of Database Fundamentals: Storage.
- I hope you're starting to get the hang of evaluating…your table structure against the normal form requirements.…Here's how I'd approach the solution.…First, I'm going to take a look at the ChallengeData.txt…file to see what we're starting with.…We can see here we have a column here for Item and Type.…In this column, we've got the item names of the products…that we carry as well as the type of item that it is.…So we've got a jacket here,…we've got some more jackets down her,…and another jacket here, for example.…Next, we have a rather long column for our descriptions,…so we have all of these here are our long descriptions here.…
I'm going to highlight, actually, all of these columns…because these all look like they are the same…product and type, and the description's the same for those,…so let's see if that continues on for the other columns…in this data table.…Let's scroll over here to the far right.…We've got another column called Sizes Available.…The sizes are all the same for each of these products,…but we can see it's a comma separated list,…
Note: This course will also prepare certification candidates for the "Understanding data storage" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Find out more at https://www.microsoft.com/learning/en-us/exam-98-364.aspx.
- Reducing redundancy with normalization
- Fixing partial dependencies
- Creating primary keys
- Linking tables with foreign keys
- Creating clustered and nonclustered indexes