Database normalization (source code)

= Database normalization
{wiki}

<Database normalization> organizes <relational schemas> using their dependencies to reduce redundant facts and update anomalies. If a table stores `(student,course,instructor,office)` and each instructor has one office, repeating the office in every enrolment creates multiple places to update. Splitting instructor-office facts into a separate relation can remove that redundancy. A decomposition must be checked for <lossless join> and, when needed, dependency preservation; merely creating more tables is not a correctness argument. Different <normal forms> impose different conditions on <functional dependencies> and other dependency types.