Q:

How do you teach database normalization?

What are your steps and guidelines for database normalization? If given a bunch of people with good computer and logic skills, how do you explain to them how to normalize a database design? What is your thought process for taking a list of attributes (fields) and turning that list into a database in 1NF? 2NF? 3NF?

A:

Check out some of these resources:

3 Normal Forms - a tutorial
Database normalization tutorial

or get your folks the best book I've found for learning database design: 
Database Design for Mere Mortals(R): A Hands-On Guide to Relational Database Design (2nd Edition) by Mike Hernandez

