Retrieve the names of employees who work on the ‘Newbenefits project. 2. Retrieve name and salary of all male employees who
Retrieve the names of employees who work on the ‘Newbenefits project. 2. Retrieve name and salary of all male employees who
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
1. Retrieve the names of employees who work on the ‘Newbenefits project.
2. Retrieve name and salary of all male employees who have dependents
3. Retrieve name of all department managers
![ΕMPLOYYEΕ
FNAME MINIT
LNAME
SSN
BDATE
ADDRESS
SEX SALARY
SUPERSSN DNO
Smith
731 Fondren, Houston, TX
638 Voss, Houston, TX
3321 Castle, Spring, TX
291 Berry, Bellaire, TX
975 Fire Oak, Humble, TX
John
B
123456789
1965-01-09
30000
333445555
5
Franklin
333445555
Wong
Zelaya
1955-12-08
M
40000
888665555
Alicia
J
999887777
1968-07-19
25000
987654321
4
Jennifer
Wallace
987654321
1941-06-20
F
43000
888665555
4
Ramesh
K
666884444
38000
333445555
Narayan
English
1962-09-15
M
5
Joyce
A
453453453
1972-07-31
5631 Rice, Houston, TX
25000
333445555
5
987987987
888665555
980 Dallas, Houston, TX
450 Stone, Houston, TX
Ahmad
V
Jabbar
1969-03-29
25000
987654321
4
James
E
Borg
1937-11-10
M
55000
nul
DEPT LOCATIONS
DNUMBER
DLOCATION
Houston
4
Stafford
DEPARTMENT
DNAME
DNUMBER
MGRSSN
MGRSTARTDATE
Bellaire
Sugarland
Research
333445555
1988-05-22
Administration
Headquarters
4
987654321
1995-01-01
Houston
1
888665555
1981-06-19
WORKS ON
ESSN
PNO
HOURS
123456789
1
32.5
123456789
2
7.5
666884444
3
40.0
453453453
1
20.0
453453453
2
20.0
PROJECT
PNAME
PNUMBER
PLOCATION
DNUM
333445555
2
10.0
Productx
ProductY
Productz
Computerization
Reorganization
Newbenefits
Bellaire
5
333445555
3
10.0
Sugarland
5
333445555
10
10.0
Houston
333445555
20
10.0
10
Stafford
4
999887777
30
30.0
20
Houston
999887777
10
10.0
30
Stafford
4
967967987
10
35.0
987987967
30
5.0
987654321
30
20.0
987654321
20
15.0
888665555
20
null
DEPENDENT
ESSN
DEPENDENT NAME
SEX
BDATE
RELATIONSHIP
333445555
Alice
F
1986-04-05
DAUGHTER
333445555
Theodore
M
1983-10-25
SON
F
SPOUSE
333445555
987654321
Joy
Abner
Michael
1958-05-03
1942-02-28
1988-01-04
M
SPOUSE
SON
DAUGHTER
123456789
M
123456789
123456789
Alce
1988-12-30
1967-05-05
Eizabeth
F
SPOUSE](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8b96cd10-112c-49cd-92e5-ec0613183672%2Fc838353c-223b-4f46-8c9c-926c155e0ac8%2F8b1ynud_processed.png&w=3840&q=75)
Transcribed Image Text:ΕMPLOYYEΕ
FNAME MINIT
LNAME
SSN
BDATE
ADDRESS
SEX SALARY
SUPERSSN DNO
Smith
731 Fondren, Houston, TX
638 Voss, Houston, TX
3321 Castle, Spring, TX
291 Berry, Bellaire, TX
975 Fire Oak, Humble, TX
John
B
123456789
1965-01-09
30000
333445555
5
Franklin
333445555
Wong
Zelaya
1955-12-08
M
40000
888665555
Alicia
J
999887777
1968-07-19
25000
987654321
4
Jennifer
Wallace
987654321
1941-06-20
F
43000
888665555
4
Ramesh
K
666884444
38000
333445555
Narayan
English
1962-09-15
M
5
Joyce
A
453453453
1972-07-31
5631 Rice, Houston, TX
25000
333445555
5
987987987
888665555
980 Dallas, Houston, TX
450 Stone, Houston, TX
Ahmad
V
Jabbar
1969-03-29
25000
987654321
4
James
E
Borg
1937-11-10
M
55000
nul
DEPT LOCATIONS
DNUMBER
DLOCATION
Houston
4
Stafford
DEPARTMENT
DNAME
DNUMBER
MGRSSN
MGRSTARTDATE
Bellaire
Sugarland
Research
333445555
1988-05-22
Administration
Headquarters
4
987654321
1995-01-01
Houston
1
888665555
1981-06-19
WORKS ON
ESSN
PNO
HOURS
123456789
1
32.5
123456789
2
7.5
666884444
3
40.0
453453453
1
20.0
453453453
2
20.0
PROJECT
PNAME
PNUMBER
PLOCATION
DNUM
333445555
2
10.0
Productx
ProductY
Productz
Computerization
Reorganization
Newbenefits
Bellaire
5
333445555
3
10.0
Sugarland
5
333445555
10
10.0
Houston
333445555
20
10.0
10
Stafford
4
999887777
30
30.0
20
Houston
999887777
10
10.0
30
Stafford
4
967967987
10
35.0
987987967
30
5.0
987654321
30
20.0
987654321
20
15.0
888665555
20
null
DEPENDENT
ESSN
DEPENDENT NAME
SEX
BDATE
RELATIONSHIP
333445555
Alice
F
1986-04-05
DAUGHTER
333445555
Theodore
M
1983-10-25
SON
F
SPOUSE
333445555
987654321
Joy
Abner
Michael
1958-05-03
1942-02-28
1988-01-04
M
SPOUSE
SON
DAUGHTER
123456789
M
123456789
123456789
Alce
1988-12-30
1967-05-05
Eizabeth
F
SPOUSE
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY