Normalisation
Data & DatabasesStoring each fact in exactly one place.
Structuring tables so a customer email lives once and everything else points at it. Changing it is then one edit rather than a thousand. Deliberately duplicating for read speed is denormalisation, and you own keeping the copies in step.
See also Foreign key, Join