The queries below are in SQL and I need them translated to relational algebra as

Question

The queries below are in SQL and I need them translated to relational algebra as best as possible.

1)

SELECT distinct playerName FROM Players INNER JOIN Teams ON Players.team IN(SELECT teamName FROM Teams WHERE leagueName='National');

2)

SELECT distinct gameID from Games INNER JOIN Teams ON Games.homeTeamID IN (SELECT teamID FROM Teams where teamName='Phillies');

3)

SELECT DISTINCT hometeamid FROM games WHERE

guestteamid = (SELECT teamid FROM teams WHERE teamname = 'Phillies')

AND guestteamid != (SELECT teamid FROM teams WHERE teamname = 'Braves')

UNION DISTINCT

SELECT DISTINCT guestteamid FROM games WHERE

hometeamid = (SELECT teamid FROM teams WHERE teamname = 'Phillies')

AND hometeamid != (SELECT teamid FROM teams WHERE teamname = 'Braves');

4)

SELECT a.playerid "playerID1", b.playerid "playerID2", a.team

FROM players a INNER JOIN players b

ON a.team = b.team

AND a.playerid != b.playerid

AND a.playerid < b.playerid;

5)

SELECT a.hometeamid "teamID1", b.leaguename "league1", a.guestteamid "teamID2", c.leaguename "league2", a.date

FROM games a INNER JOIN teams b

ON a.hometeamid = b.teamid

INNER JOIN teams c

ON a.guestteamid = c.teamid

WHERE

b.leaguename != c.leaguename;

6)

SELECT DISTINCT a.home

FROM teams a INNER JOIN teams b

ON a.home = b.home

AND a.teamname != b.teamname

AND a.leaguename != b.leaguename;

Explanation / Answer

Hi Question 3, 4, 5 and 6 are answered below.

Plz have a look:

Answer 3:

? guestteamid/hometeamid (? hometeamid ?teamname=

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.