3NF – Third Normalized Form

• The Primary Function of 3NF is the elimination of any Transitive Dependencies
• A Transitive Dependency is a Dependency on a non key field

Cooking Table

We realized that some of our ingredients needed to be processed in stages so we came up with the Sub Step Variable

Our Rest Variable now happens at the end of a Sub Step

The Rest data is Dependent not on the Key (RecipeID + IngrOrd) but on the SubStep Data

This is a Transitive Dependency