For the Of-the-Month Club exercises in Chapter 5

(R, S), Chapter 6 (Q), Chapter 7 (K), Chapter 8 (K, L), and Chapter 9 (E):

1. Apply the rules of normalization to the class diagram to check the diagram for processing efficiency.

2. Develop a clustering and indexing strategy for this model. Describe how your strategy will improve the performance of the database.