Consider the following normalized relations for a sports league and assume that the database is global in scope and covers thousands of leagues, tens of thousands of teams, and hundreds of thousands of players. team(teamid, teamname, teamlocation, teammanager, teamleague) player(playerid, playerfirstname, playerlastname, playerdateofbirth, playerspecialtycode, teamid) specialty(specialtycode, specialtydescription, salary) location(locationid, cityname, citystate, citycountry, citypopulation) manager(managerid, managername) league(leagueid, leaguename, leaguelocation) a. do you see any denormalization opportunities? b. what are the first steps that you can take to improve the performance of the database? c. specify the types of indexes you would recommend for each of the following situations: 1. reporting players by team using the team name reporting players of a specific specialty using the specialty code. 2. how is your answer different if the report is using specialty description as input? 3. reporting the players whose salary is above a specific value. 4. reporting teams and their players by city d. do you see any partitioning opportunities based on the above queries?