1. Consider the following SQL query and related relations

SELECT StudId, Lname

FROM Student s, Grades g, Course c

WHERE s.StudId=g.StudId AND g.CrsId=c.CrsId

AND Grade=A + AND Dept =Comp AND Major= Math;

Where :

Student({Lname,Fnamem,StudId,Major})

Grades({StudId , CrsId ,Grade})

Course({Cname, CrsId ,Points,Dept})

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

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