Learn the process of normalization (1NF, 2NF, 3NF, BCNF, 4NF) to design efficient, reliable, and redundancy-free database schemas using functional dependencies.
Ensure your tables have atomic values and no repeating groups.
Eliminate partial dependencies on a composite primary key.
Eliminate transitive dependencies on the primary key.
Understand the stricter version of 3NF, Boyce-Codd Normal Form.
Learn about 4NF and how it deals with multi-valued dependencies.
Understand when and why you might intentionally violate normal forms.
Learn the theoretical concept of functional dependency that underpins normalization.