Reference no: EM131546154

Please submit the relational algebra answers to the following questions in a Word document.

Questions

1. Using the Master table, List players born in New York state in 1978. The output should contain their full name (First, given and last)

2. Using the Master and Appearances tables, select players born in the state of New Jersey in 1987, the years they appeared on the All-Star teams. Your answer should return the playerID, their full name (First, given and last) and the years they appeared on the AllStars.

3. Using the Appearances, what are the playerID for the players that appeared on both the 2000 and 2010 AllStar teams

4. Using the Master, Appearances, Teams and TeamsFranchises tables, select players born in New Jersey in 1987, the years they appeared on the All-Star teams and the name of the franchise they played for.

5. Using the Master and Salaries tables, write query that names of players whose salaries were between $80,000.00 and $90,000.00

6. Using the Managers, Hall of Fame and Master tables, write the query that returns all managers of AllStar teams that are also in the Hall of Fame

Note: The appearances table shows the years that someone was named to (appeared) the Allstar team. Allstarfull shows the actual games played by a specific player.

You are being asked to submit the Relational Algebra formulas, not any SQL statements.