The relational database architecture stands on solid mathematical footing. Central to the math behind the relational architecture is the concept of normalization. This presentation goes through each of the major normal forms, describing (with examples each step along the way) how to get into each normal form, why you want to be in that normal form, and how to recognize when you are not in that normal form. This talk will show you exactly why good normalization technique is vital in relational database design.
Click here to access the slides for this presentation.
The slides are licensed under Creative Commons Attribution-ShareAlike.
Click here to access demo code for this presentation. These scripts give you an opportunity to play with 4NF and 5NF examples.
In addition, thanks to Diane Wilson's help, you can also get a full walkthrough of normalization from 0NF through 5NF in ZIP format. This example is built around the band King Crimson
The source code is licensed under the terms offered by the GPL.