$3$ Query Processing $[10]$

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 $=1234$SC$$

Propose an optimized execution plan for this query.

Which indexes should be created to support the execution plan.