DDEPARTMENTSColumna Data Model IConstraints iGrants Istatutica Triogers irlahback Dependendes Detals i* a E X Sort. Fiter.DEPARTMENT... DEPARTHENT NAME10 Administration() MANAGER_ JD ) LOCATIONUD170020020 Marketing201180030 Purchasing40 Human Resources1141700203240050 Shapping1211500€0 IT103140070 Public Relationa204270080 Sales145250090 Executive100170010100 Finance108170011110 Accounting205170012120 Treasury(null)170013130 Corporate Tax(null)170014140 Control And Credit(null)170015150 Shareholder Services(null)170016160 Benefita(aull)170017170 Manufacturing(null)170018180 Construction(null)170019190 Contracting(null)700ב20200 Operations1700(null)(null)21210 IT Support170022220 NOC(null)170023230 IT Helpdesk(null)1700DepartmentsEMPLOYEE JD FIRST NAME LAST NAME EMAL101 Neena0 HIRE DATE ) 08D21-SEP-89 AD VP10 PHONE NUMBERSALARY COMMESSION PCT ) MANAGER D DEPARTMENT IDKochharSROCHHAR S15.123.456817000(null)10090170001100079000600102 Lex13-JAN-93 AD_VP07-DEC-94 FU MAN01-MAY-95 ST MANJTAYLOR 011.44.1644.429265 24-MAR-98 SA REP17-SEP-87 AD_ASSTDe HaanLDENAAN 515.123.4569(null)10090Raphaely DRAPHEAL 515.127.4561Kaufling PKAUFLIN 650.123.3234114 Den(null)10030122 Payam(null)10050176 Jonathon Taylor0.214980200 Jennifer WhalenJWHALEN 515.123.44444400(null)10110201 MichaelHartatein MHARTSTE S15.123.555517-FEB-96 MK_MAN 13000(null)10020CemployeesWhat SQL statement will show the last name and the department name of Payan Kaufling?• SELECT C.Last_name, D.Department_nameFROM DEPARTMENTS D UNION JOIN CEMPLOYEES CWHERE D.DEPARTMENT_ID = C.DEPARTMENT_ID AND C.LAST_NAME = "Kaufling;• SELECT C.Last_name, D.Department_nameFROM DEPARTMENTS D INNER JOIN CEMPLOYEES CWHERE D.DEPARTMENT ID = C..DEPARTMENT ID ANDC.LAST NAME = 'Kaufling' AND C.FIRST_NAME = 'Payan';• SELECT C.Last_name, D.Department_nameFROM DEPARTMENTS D INNER JOIN CEMPLOYEES CWHERE C.LAST_NAME = "KAUFLING' AND C.FIRST_NAME = 'PAYAN";• SELECT C.Last_name, D.Department_nameFROM DEPARTMENTS D AND CEMPLOYEES CWHERE D.DEPARTMENT_ID = C..DEPARTMENT_ID ANDC.LAST_NAME = 'Kaufling' AND C.FIRST_NAME = 'Payan';

b is the correct option Select C.Last_name,D.Department_name From DEPARTMENTS D INNER JOIN…

130 Corporate Tax 170 Manufacturing 180 Construction ODEPARTMENTS Columne Data Model IConstraints Grants Istatetics Triopers Pahback Dependences IDetals *a X Sort Fiter DEPARTMENT. DEPARTHENT NAME MANAGER DLOCATIONJD 1700 10 Adminiatration n 200 20 Marketing 201 2800 30 Purchasing 114 1700 4. 40 Human Resources 203 2400 S0 Shapping 40 IT 70 Publie Relationa 121 1500 6. 103 1400 204 2700 80 Sales 145 2500 9. 90 Executave 100 1700 10 100 Fanance 108 8 1700 11 110 Accounting 205 1700 12 120 Treasury (null) 1700 13 (nuil) 1700 14 140 Control And Credit (null) 1700 15 150 Shareholder Services (null) 1700 16 140 Benetita (null) 1700 17 (null) 1700 18 (null) 1700 19 190 Contracting (nul1) 1700 20 200 Operations (null) 1700 21 1700 210 IT Support 220 NOC (null) 22 (null) (null) 1700 23 230 IT Helpdesk 1700 Departments ) DHPLOYEE_ JD () PIRST_JNAME () LAST NAME () EMAR. 0PHONE NUMER SALARY COMMESSION PCT MANAGER JD 0 HORE DATE 0J08D 21-SEP-89 AD_VP 13-JAN-93 AD VP 17000 17000 11000 7900 8600 (null) (null) 101 Neena Kochhar SROCHHAR S15.123.4568 100 102 Lex De Haan LOENAAN S15.123.4569 100 114 Den Raphaely DRAPHEAL S15.127.4561 Kaufling PRAUFLIN 650.123.3234 07-Dec-94 FU MAN (null) 100 01-MAY-95 ST MAN JTAYLOR O11.44.1644.429265 24-AR-90 SA REP 17-SEP-87 AD_ASST 17-PEB-96 MK MAN 122 Payan (null) 100 176 Jonathon Taylor 0.2 149 200 Jennifer Whaien JWHALEN S15.123.4444 4400 (null) 101 201 Michael Hartstein MIARTSTE S15.123.5555 13000 (null) 100 Cemployees What SQL statement will show the last name and the department name of Payan Kaufling? SELECT CLast name, D.Department_name FROM DEPARTMENTS D UNION JOIN CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST NAME = 'Kaufling': • SELECT C.Last_name, D.Department_name FROM DEPARTMENTS D INNER JOIN CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST NAME = 'Kaufling' AND C.FIRST NAME = "Payan'; ; SELECT C.Last name, D.Department_name FROM DEPARTMENTSD INNER JOIN CEMPLOYEES C WHERE C.LAST NAME = "KAUFLING' AND C.FIRST NAME = 'PAYAN'; • SELECT C.Last_name, D.Department_name FROM DEPARTMENTS D AND CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST_NAME = 'Kaufling' AND C.FIRST_NAME = 'Payan';

130 Corporate Tax 170 Manufacturing 180 Construction ODEPARTMENTS Columne Data Model IConstraints Grants Istatetics Triopers Pahback Dependences IDetals *a X Sort Fiter DEPARTMENT. DEPARTHENT NAME MANAGER DLOCATIONJD 1700 10 Adminiatration n 200 20 Marketing 201 2800 30 Purchasing 114 1700 4. 40 Human Resources 203 2400 S0 Shapping 40 IT 70 Publie Relationa 121 1500 6. 103 1400 204 2700 80 Sales 145 2500 9. 90 Executave 100 1700 10 100 Fanance 108 8 1700 11 110 Accounting 205 1700 12 120 Treasury (null) 1700 13 (nuil) 1700 14 140 Control And Credit (null) 1700 15 150 Shareholder Services (null) 1700 16 140 Benetita (null) 1700 17 (null) 1700 18 (null) 1700 19 190 Contracting (nul1) 1700 20 200 Operations (null) 1700 21 1700 210 IT Support 220 NOC (null) 22 (null) (null) 1700 23 230 IT Helpdesk 1700 Departments ) DHPLOYEE_ JD () PIRST_JNAME () LAST NAME () EMAR. 0PHONE NUMER SALARY COMMESSION PCT MANAGER JD 0 HORE DATE 0J08D 21-SEP-89 AD_VP 13-JAN-93 AD VP 17000 17000 11000 7900 8600 (null) (null) 101 Neena Kochhar SROCHHAR S15.123.4568 100 102 Lex De Haan LOENAAN S15.123.4569 100 114 Den Raphaely DRAPHEAL S15.127.4561 Kaufling PRAUFLIN 650.123.3234 07-Dec-94 FU MAN (null) 100 01-MAY-95 ST MAN JTAYLOR O11.44.1644.429265 24-AR-90 SA REP 17-SEP-87 AD_ASST 17-PEB-96 MK MAN 122 Payan (null) 100 176 Jonathon Taylor 0.2 149 200 Jennifer Whaien JWHALEN S15.123.4444 4400 (null) 101 201 Michael Hartstein MIARTSTE S15.123.5555 13000 (null) 100 Cemployees What SQL statement will show the last name and the department name of Payan Kaufling? SELECT CLast name, D.Department_name FROM DEPARTMENTS D UNION JOIN CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST NAME = 'Kaufling': • SELECT C.Last_name, D.Department_name FROM DEPARTMENTS D INNER JOIN CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST NAME = 'Kaufling' AND C.FIRST NAME = "Payan'; ; SELECT C.Last name, D.Department_name FROM DEPARTMENTSD INNER JOIN CEMPLOYEES C WHERE C.LAST NAME = "KAUFLING' AND C.FIRST NAME = 'PAYAN'; • SELECT C.Last_name, D.Department_name FROM DEPARTMENTS D AND CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST_NAME = 'Kaufling' AND C.FIRST_NAME = 'Payan';

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Applications

Section: Chapter Questions

Problem 2SAT

See similar textbooks