Problems 1 through 5 are based on the Fitchwood Insurance Company case study, which...

Problems 1 through 5 are based on the Fitchwood Insurance Company case study, which was described in the Problems and Exercises for Chapter 9, and the associated Figure 9-26.

Reference figure 9-26

After some further analysis, you discover that the commission field in the Policies table is updated yearly to reflect changes in the annual commission paid to agents on existing policies. Would knowing this information change the way in which you extract and load data into the data mart from the OLTP system?