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.