Question

Please clear and direct answer

Consider the following SQL query and related relations         

SELECT P.Name

FROM Players P, Games G

WHERE P.Id = G.PlayerId

     AND P.Game = 'Football' AND G.Season ='2019'

where:

Players (Id, Name, Game)

Games (PlayerId, GameCode, Season)

1. Translate the above SQL query to a relational algebra expression.

2. Draw the Query tree for above relational algebra expression in part (a).

Answer 1

Here first in tree i have used projection then selection and then join (equi).

Hope this is help full.

Thanks