. 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.