For the A Video Store problem in Chapter 4 and Chapter 5 (Attached). Apply the rules of normalization to the class diagram to check the diagram for...

For the A Video Store problem in Chapter 4 and Chapter 5 (Attached).1. Apply the rules of normalization to the class diagram to check the diagram for processing efciency.2. Develop a clustering and indexing strategy for this model. Describe how your strategy will improve the performance of the database.