Consider Figure 4-36 and your answer to Problem and Exercise 19 in Chapter 4. Assume tha...

Consider Figure 4-36 and your answer to Problem and Exercise 19 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.