Complete the following exercises. I think the easiest way to do these is by hand and then scan them in, but you are velcome to use a graphic tool if that is easier for you. Please show your work. The global schema for use in this assignment. \begin{tabular}{|} \hline EMP (ENO, ENAME, TITLE) \\ ASG (ENO, PNO, RESP, DUR) \\ PROJ (PNO, PNAME, BUDGET) \\ \hline \end{tabular} Problem A. For the following SQL query on the example database, SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE DUR >12 AND EMP.ENO = ASG. ENO AND PROJ.PNO = ASG.PNO Problem B. For the following SQL 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 ASG.PNO = PROJ.PNO Simplify the query and transform it into an optimized operator tree using the restructuring algorithm (section 7.1.4 of the Query Decomposition reading), where the select and project operations are applied as soon as possible to reduce the size of intermediate relations. Transform the following query into a reduced query on fragments: SELECTENO,PNAMEFROMPROJ,ASGWHEREPROJ.PNO=ASG.PNOANDPNO="P4