Designing relational databases that avoid anomalies.
3 free units in this chapter
A good relational design stores each fact in an appropriate place and connects related facts through keys. A primary key identifies a row uniquely; a foreign key references an existing related row. Referential integrity…
About 8 minPoorly designed tables develop predictable diseases: redundancy and the three anomalies. Recognising them motivates normalisation.
About 4 minNormalisation splits a bloated table into related tables so each fact lives once — eliminating the anomalies at their source.
About 4 min