Databases

Explain Normalization

Difficulty: unrated

Source: bregman-arie/devops-exercises by Arie Bregman

Answer

Data that is used multiple times in a database should be stored once and referenced with a foreign key.

This has the clear benefit of ease of maintenance where you need to change a value only in a single place to change it everywhere.