Normalization
Normalization theory is based on the observation that relations with certain properties are more effective in inserting, updating and deleting data than other sets of relations containing the same data
Normalization is a multi-step process beginning with an “unnormalized” relation
- Hospital example from Atre, S. Data Base: Structured Techniques for Design, Performance, and Management.