Simplify the following query:
SELECT ENAME, PNAME
FROM EMP, ASG, PROJ
WHERE (DUR > 12 OR RESP = "Analyst")
AND EMP.ENO = ASG.ENO
AND (TITLE = "Elect. Eng." OR ASG.PNO <>
AND (DUR > 12 OR RESP NOT= "Analyst")
AND ASG.PNO = PROJ.PNO
Also transform it into an optimized operator tree using the restructuring algorithm where select and project operations are applied as soon as possible to reduce the size of intermediate relations.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here