Question: 1-Draw the query graph .2-Draw the initial query tree, then show how the same query tree is improved by optimizing the inferential rules in another
Q 2: SELECT E.Fname, E.Lname, S.Fname, S.Lname FROM EMPLOYEE AS E, EMPLOYEE AS S WHERE E.Super_ssn=S.Ssn; Q 3: SELECT E.Fname, E.LName, E.Address FROM EMPLOYEE E, DEPARTMENT D WHERE D.DName='Research' AND D.Dnumber=E.Dno; Q 4: SELECT Pnumber, Pname, COUNT (*) FROM PROJECT, WORKS_ON, EMPLOYEE WHERE Pnumber=Pno AND Ssn=Essn AND Dno=5 GROUP BY Pnumber, Pname
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
