Consider the following query

select s.name

from students s, courses c, transcripts t

where s.ID = t.ID and

c.CNO = t.CNO and

s.dept = CS and

t.grade = A

(a) Write the query as a relational algebra query in the form

attributescondition(sct)

(b) Write 5 other equivalent RA queries. Try to write queries that allow more efficient processing.

(c) Draw the query trees (query plans without algorithm specification) for the queries you gave in part (b).