Consider the following database:

Consider the query:

SELECT E.Lname, E.Bdate, D.Mgr_ssn

FROM EMPLOYEE AS E, DEPARTMENT AS D

WHERE E.Salary >= 30000 AND D.Dname = Administration

AND E.Dno = D.Dnumber;

1. Apply the query on two different methods given below and show the intermediate relations.

Method 1: Apply Join first and then Selection according to given conditions

Method 2: Apply Selection

EMPLOYEE Fname Minit | Lname Ssn Bdate Address Sex Salary Super_ssn Dno John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 3334455555 Franklin IT Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 8886655555 Alicia Zelaya 999887777 1968-01-19 3321 Castle, Spring, TXF 25000 9876543214 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 4 Ramesh | Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 3334455555 Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 3334455555 V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TXM 25000 9876543214 James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL | 1 DEPARTMENT Dnumber Dname Research Administration Headquarters Mgr_ssn 333445555 987654321 888665555 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 4 1 DEPT_LOCATIONS Dnumber Dlocation 1 Houston Stafford Bellaire Sugarland 5 Houston 4 5