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 first and then Join according to given conditions

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