In Figure 7-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 7-10: Using triggers to maintain normalized data
