Aim: Aim: Simplify the following query: SELECT ENAME, PNAME FROMEMP, ASG, PROJ WHERE $($DUR $>12$ OR RESP $=$ "Analyst"$)$AND EMP.ENO $=$ ASG.ENOAND $($TITLE $=$ "Elect. Eng." OR ASG.PNO $<"$P$3")$AND $($DUR $>12$ OR RESP NOT$=$ "Analyst"$)$ AND ASG.PNO $=$ PROJ.PNO PROJ.PNO where select and project operations are applied as soon as possibleto reduce the size of intermediate relations Objective: To understand and implement the concept of query optimization