Schema Design and Normalisation
Functional dependencies, normal forms, and translating real-world entities into clean schemas.
A poorly designed schema leads to update anomalies and data inconsistency. This chapter introduces entity-relationship modelling, functional dependencies, and the first through third normal forms — with worked examples of decomposing poorly structured tables.