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.
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.