Get Normal
Copyright © 1995 Craig Edward Given
Table of Contents
Course Overview
What is normalization? Why is it important? How long with this tutorial take?
Example Scenario
An imaginary kennel has an unnormalized database. We examine their situation and current data layout.
What is a "Relational" Database?
Where they originated, primary attributes, and relational operators.
Make it Relational
We convert our scenario data from paper records into a table of a relational database.
The 1NF: Eliminate Repetition
Notation System for ERD's
Notational conventions to diagram entity relationships
The 2NF: Eliminate Redundancy
The 3NF: Eliminate Transitive Dependencies
Weaknesses of the 3NF
Referential Integrity
Hands-On Exercises
ERD Exercise: Final Brain Buster
Bibliography
Copyright © 1995 Craig Edward Given