1. Proposing and creating a set of indexes, based on your final database schema, that you expect to improve query running time; you must justify each proposed index by identifying which queries you expect to benefit from these indexes.

2. Improving the query performance by altering the database schema, e.g., de-normalization (reversing BCNF or 3NF to avoid joins), or further decomposition (to reduce the amount of useless data a query finds in each tuple). Please discuss how you will modify your schema to improve the query performance.

3. Evaluating the query speed up for selected queries which highlight the impact of your proposed optimizations. You also need to generate some dummy data for your tables