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 12 OR RESP NOT= "Analyst") AND...


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.



Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here