Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following database: EMPLOYEE Frame Minit John B Franklin T AliciaJ Jennifer S Ramesh K Joyce A Ahmad V James E Lnamo San Bdate

image text in transcribed

Consider the following database: EMPLOYEE Frame Minit John B Franklin T AliciaJ Jennifer S Ramesh K Joyce A Ahmad V James E Lnamo San Bdate Address Sex Smith 123456780 1965-01-09 731 Fondren, Houston, TX M Wong 333445555 1955-12-08 638 Voss, Houston, TX M Zelaya 999887777 1968-01-19 3321 Castle, Spring. TXF Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M English 453453453 1972-07-31 5631 Rice, Houston, TX F Jabbar 087987987 1969-03-29 980 Dallas, Houston, TX M Borg 888665555 1937-11-10 450 Stone, Houston, TX M Salary Super_ssn Dno 30000 3334455555 40000 8886655555 25000 9876543214 43000 888665555 38000 333445555 5 25000 333445555 5 25000 9876543214 55000 NULL DEPARTMENT DEPT_LOCATIONS Dnumber Dlocation Drame Dnumber Research Administration Headquarters Mgr_ssn 333445555 987654321 888665555 Mgr_start_date 1988-05-22 1995-01-01 1 981-06-19 Houston Stafford Bellaire 1 Sugarland Houston 5 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

e. What do you know about your ethnic background?

Answered: 1 week ago

Question

b. Why were these values considered important?

Answered: 1 week ago