Consider the following query that joins Student(sid, sname, sdept), Enrollment(sid, cid), Courses(cid,

ctitle, iid), Instructor (iid, iname, iaddr). The names of the attributes are intuitive

SELECT sname, ctitle, iname

FROM Student S, Enrollment E, Course C, Instructor I

WHERE S.sid = E.sid

AND E.cid = C.cid

AND C.iid = I.iid

AND S.sdept = CS

AND I.iaddr = 1234SC

1. Propose an optimized execution plan for this query.

2. Which indexes should be created to support the execution plan.