Question: How many rows will the following SQL statement return given the Employee and Department tables shown? SELECT EMP_NAME, EMP_JOB FROM EMPLOYEE emp, DEPARTMENT dep WHERE

How many rows will the following SQL statement return given the Employee and Department tables shown?

SELECT EMP_NAME, EMP_JOB

FROM EMPLOYEE emp, DEPARTMENT dep

WHERE emp.DEP_NO = dep.DEP_NO AND

dep.DEP_LOCATION = 'Boston';

How many rows will the following SQL statement return given the Employee

DEPARTMENT EMPLOYEE DEP NOI DEP NAMEB DEP LOCATION | EMP IDEMP NAME DEP NO 10 EMP-JOB 10 AccourtingNew York 20 Research 30 Sales 40 Cperations 7839 King 7566 Jones 7698 Blake 7782 Clark 7902 Ford 7369 Smith 7499 Allen 7521 Ward 7654 Martin 7788 Scott 7844 Turner 7876 Adams 7900 James 7934 Miller President Manager Manager Manager Analyst Clerk Salesman Salesman Salesman Analyst Salesman Clerk Clerk Clerk Dallas Dallas Boston 20 2 3 10 20 20 30 30 30 20 Important: Dep no in EMPLOYEE is the foreign key that references the primary key Dep_no in DEPARTMENT. 10 20 12 13 14 10

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!