Normalization

Normalize

What's It All About?

(headshot) The Rules

为什么要normalization

Not A Relation

repeat others

Relation With Problems

Relation With Problems-Redundancy

inconsistant

Relation With Problems-Insertion Anomaly

Relation With Problems-Deletion Anomaly

Relation With Problems-Update Anomaly

Information Loss

Dependency Loss

Perfect

Functional Dependencies

Full Functional Dependencies

Functional Dependencies And Keys

Overview Of Normal Forms

boys coddd normal forms

Normal Forms-Definitions

Kent And Diehr Quote

1NF BCNF Flow Chart

when decompose since age, we got BCNF EMAIL determine birth year and then birth year determine salary(transit)

Compute With Functional Dependencies-Armstrong's Rules

How To Guarantee Lossless Joins

How To Guarantee Preservation Of FDs

Email Interest

3NF And BCNF

It Nevers Happens In Practice