We Have Normality

WARNING!

This presentation is now obsolete. The information in this talk has not been updated in a while and could be outdated. Use the information in this presentation at your own risk and be sure to double-check things to ensure that any information you use is accurate.

ABSTRACT

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.

ADDITIONAL MEDIA

No recordings or additional media are available for this talk.

DEMO CODE

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.