Using the guidelines provided in Appendix G, decide when you might consider denormalization for PerfectPets.
Appendix G
There may be situations where we have to run certain reports at peak times during the day. These reports access derived data and perform multi-table joins on the same set of base tables. However, the data the report is based on may be relatively static or, in some cases, may not have to be current (that is, if the data was a few hours old, the report would be perfectly acceptable). In this case, it may be possible to create a single, highly denormalized extract table based on the tables required by the reports, and allow the users to access the extract table directly instead of the base tables. The most common technique for producing extract tables is to create and populate the tables in an overnight batch run when the system is lightly loaded