A)@who are working on projects that are located in Houston. ast name. Make a list of the SSN of all employees who are working in department number 4 or employees B)@ Retrieve the names of employees who work on all the projects in which the employee with ssn 453453453' is working on. C)@For every project located in 'Sharjah', retrieve the project name, the controlling department name and the department manager's last name.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

*Give correct Answer and get upvote

*Else I will give downvoted 

 

 

 

EMPLOYEE
Fname
Minit Lname
San
Bdate
Address
Sex Salary Super san Dno
kohn
123456789 1965-01 09 701 Fondren, Hoton, TX M a0000 aa3445556
Sith
Wong 333445565 1955 12-00 638 Voss, Hlouston, TX M 40000 80665565
Frankn T
JZelaya 99A87 1968-01-19 3321 Castle, Spring TX
Wallace u7054321 1941-06-20 201 Berry, Blellaire, TX
F25000 9a7654321
F 43000 eeneSS55
Alcia
4
Jenier
Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humbe, TX M 38000 333445555
A Engiuh 453453453 1972 07 31 5e31 Rion, Houston, TX E 2500 a344565
987987987 1969-09 29 980 Dalas, Houston, TX M 25000 9865421 4
nnnGasS6s 1907-11-10 450 St, Houston, TX Ms5000 NULL
kayce
Ahmad
Jabbar
lames
Borg
DEPARTMENT
DEPT LOCATIONS
Dunder
Deuber
Dcation
Dhane
Reearch
My start due
1988-05-22
13445555
Houton
Abiin
1905-01-01
Saord
Headquarters
1981-06-19
Belure
Sugutand
Houston
WORKS ON
PROJECT
Esan
Hous
Pae
Pecation
Bel
Dum
123456799
32.5
ProductX
12345679
75
ProrY
Sugaland
666884444
40.0
Produc
Hounton
20.0
Computeriatn
Roceganialion
459453459
10
Stalked
45345045
20.0
20
Hounion
3334466
10.0
Nowbenefes
30
Stalked
10.0
333445555
10
10.0
DEPENDENT
33344ts
20
10.0
Dapandent na
Sex
date
Rolatinhip
1900-04 6 Daghte
1943 10 25 Son
1960 00 Spoe
30
300
Alce
10
100
Thoodore
10
36.0
koy
5.0
Alner
M
1942 02 20 Spouse
30
20.0
193466709
Mchal
M.
1900-01-04
Sen
15.0
1900 12 30 Daghte
197 6 06 Spone
20
Alen
20
NULL
123466780
Eabeth
Transcribed Image Text:EMPLOYEE Fname Minit Lname San Bdate Address Sex Salary Super san Dno kohn 123456789 1965-01 09 701 Fondren, Hoton, TX M a0000 aa3445556 Sith Wong 333445565 1955 12-00 638 Voss, Hlouston, TX M 40000 80665565 Frankn T JZelaya 99A87 1968-01-19 3321 Castle, Spring TX Wallace u7054321 1941-06-20 201 Berry, Blellaire, TX F25000 9a7654321 F 43000 eeneSS55 Alcia 4 Jenier Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humbe, TX M 38000 333445555 A Engiuh 453453453 1972 07 31 5e31 Rion, Houston, TX E 2500 a344565 987987987 1969-09 29 980 Dalas, Houston, TX M 25000 9865421 4 nnnGasS6s 1907-11-10 450 St, Houston, TX Ms5000 NULL kayce Ahmad Jabbar lames Borg DEPARTMENT DEPT LOCATIONS Dunder Deuber Dcation Dhane Reearch My start due 1988-05-22 13445555 Houton Abiin 1905-01-01 Saord Headquarters 1981-06-19 Belure Sugutand Houston WORKS ON PROJECT Esan Hous Pae Pecation Bel Dum 123456799 32.5 ProductX 12345679 75 ProrY Sugaland 666884444 40.0 Produc Hounton 20.0 Computeriatn Roceganialion 459453459 10 Stalked 45345045 20.0 20 Hounion 3334466 10.0 Nowbenefes 30 Stalked 10.0 333445555 10 10.0 DEPENDENT 33344ts 20 10.0 Dapandent na Sex date Rolatinhip 1900-04 6 Daghte 1943 10 25 Son 1960 00 Spoe 30 300 Alce 10 100 Thoodore 10 36.0 koy 5.0 Alner M 1942 02 20 Spouse 30 20.0 193466709 Mchal M. 1900-01-04 Sen 15.0 1900 12 30 Daghte 197 6 06 Spone 20 Alen 20 NULL 123466780 Eabeth
A)@who are working on projects that are located in Houston. ast name.
Make a list of the SSN of all employees who are working in department number 4 or employees
B)@ Retrieve the names of employees who work on all the projects in which the employee with ssn 453453453' is working on.
C)@For every project located in 'Sharjah', retrieve the project name, the controlling department name and the department manager's last name.
Transcribed Image Text:A)@who are working on projects that are located in Houston. ast name. Make a list of the SSN of all employees who are working in department number 4 or employees B)@ Retrieve the names of employees who work on all the projects in which the employee with ssn 453453453' is working on. C)@For every project located in 'Sharjah', retrieve the project name, the controlling department name and the department manager's last name.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Graphical User Interface
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education