Database Normalization

Use dependencies to reduce update, insertion, and deletion anomalies, while keeping historical facts at the grain where they belong.