Normalization, Denormalization, and Primary Index Usage
The following example shows how a well‑designed normalized table set can be as high-performing as the equivalent denormalized form while avoiding all the redundancy and update anomaly difficulties of denormalization. Note that denormalization is a logical, not a physical, concept (see Chapter 7: “Denormalizing the Physical Schema”). The term is used here only because it is most commonly understood in such a context, not because it is correct.
The most frequently performed query against these tables determines the current price for a given part.