Material Detail

3 Normal Forms Database Tutorial

3 Normal Forms Database Tutorial


This is meant to be a very brief tutorial aimed at beginners who want to get a conceptual grasp on the database normalization process. I find it very difficult to visualize these concepts using words alone, so I shall rely as much as possible upon pictures and diagrams.

To demonstrate the main principles involved, we will take the classic example of an Invoice and level it to the Third Normal Form. We will also construct an Entity Relationship Diagram (ERD) of the database as we go.



More about this material


Log in to participate in the discussions or sign up if you are not already a MERLOT member.
Antonio Silva Sprock
Antonio Silva Sprock (Teacher (K-12))
4 years ago

Should propose exercises.

Used in course? Yes