Consider Figure 4-38 and your answer to Problem and Exercise 4-48 in Chapter 4.

Assume that the most important reports that the organization needs are as follows:

• A list of the current developer’s project assignments

• A list of the total costs for all projects

• For each team, a list of its membership history • For each country, a list of all projects, with projected end dates, in which the country’s developers are involved • For each year separately, a list of all developers, in the order of their average assignment scores for all the assignments that were completed during that year Based on this (admittedly limited) information, make a recommendation regarding the indexes that you would create for this database. Choose two of the indexes and provide the SQL command that you would use to create those indexes.