Normalization workshop

Talk Type: 

3 Hour tutorial

Technical Level: 
Beginner
License: 
Public Domain

Three segment normalization workshop, as presented at East and West conferences previously.

First segment - database history, current trends, future possibilities, normal forms, normalization, denormalization
Second segment - whiteboard exercise - the audience participates in a presenter-led discussion and example of how to take a simple real-world example, extract its dataset, and move that dataset to first normal form, second normal form, and finally to third normal form
Third segment - audience breaks into small teams, and each group works on a normalization scenario. At the end, each group presents its normalized data set, and discusses how they worked through to their final product.