Data sig: SQL: We Have Normality- Kevin Feasel, Diane Wilson

We Have Normality - Diane Wilson and Kevin Feasel

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.

In addition, we will work through an example of normalizing a single data model from 0NF through 5NF.

Diane is a senior software engineer with Fujifilm Medical Systems, where she wrestles daily with SQL Server, Oracle, and occasional alligators.

Kevin Feasel is a database engineer at ChannelAdvisor, where he specializes in database design, performance tuning, and pulling rabbits out of hats on demand. He can be found cycling the trails of the Research Triangle whenever the weather's nice enough.