Graphics : Data Analysis

I am playing with some graphics from my data analysis career.

 

 

Normalization : Revisited

Since I last talked about normalization,, I have had the challenge of retaining the concepts as simply as possible after two years of not really thinking about them much at all.

After some thought, I decided terminology and text examples were not the answer to retention. A strong visual aid was necessary. And so the following diagram:

The diagram addresses the following normal forms:

• 0 NF Assemble Sample Data – Identify data samples and perform normalization as a best practice
• 1 NF Eliminate Repeating Groups – Identify each repeating attribute group, create a table for each group.
• 2 NF Eliminate Composite Key Independent Groups – Identify attribute groups depending on only part of composite key, create a table for each group.
• 3 NF Elimnate Single Key Independent Groups -Identify attribute groups not describing key, create a table for each group.