In Figure 6-10, the sum_adv column in the titles table stores denormalized data. A trigger updates the sum_adv column whenever the advance column in titleauthor changes.
Figure 6-10: Using triggers to maintain normalized data
