Minit Lnamo Smith 123456789 1965-01-09 731 Fondron, Houston, TX M 30000 33344555 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 88866555 Zolaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 S Wallace 987654321 1941-06-20 291 Borry, Bollairo, TX 43000 888665555 Narayan 666884444 1962-09-15 075 Firo Oak, Humblo, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX 25000 333445555 V Jabbar 987987987 1969-03-20 980 Dallas, Houston, TX M 25000 087654321 E Borg 888665555 1937-11-10 450 Stono, Houston, TX M 55000 NULL TMENT DEPT LOCATIONS name Dnumber Mgr ssn Mgr start date Dnumbor Dlocale parch 333445555 1988-05-22 Houston ministration 987654321 1995-01-01 4. Stafford dquarters 888665555 1981-06-19 5. Bellaire Sugarlan Houston PROJECT KS ON Essn Pname Prumber Plocation Dnum Pno Hours 3456789 32.5 ProductX Bellaire 1 Sugadand

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...
icon
Related questions
Question
EMPLOYEE
Fnamo
Minit
Lname
Ssn
Bdato
Ser Salary
Address
Super ssn Dno
123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555
333445555 1055-12-08 638 Voss, Houston, TX
John
Smith
Franklin
Wong
M 40000 888665555
Alicia
Zolaya
999887777 1968-01-19 3321 Castle, Spring, TX
25000 987654321
4.
Jonnifor
S
Wallace 987654321 1941-06-20 291 Borry, Bollairo, TX
F 43000 B88665555
4.
Narayan 666884444 1962-09-15 075 Fire Oak, Humblo, TX M 38000 333445555
English 453453453 1972-07-31 5631 Rice, Houston, TX
Ramesh
Joyce
25000 333445555
Ahmad
Jabbar
987987987 1960-03-20 980 Dalas, Houston, TX
M 25000 087654321
4.
James
E
Borg
888665555 1937-11-10 450 Stone, Houston, TX
M 55000 NULL
1
DEPARTMENT
DEPT LOCATIONS
Dnamo
Dnumber
Mgr ssn
Mgr start date
Dnumbor
Dlocation
Rosearch
333445555
1988-05-22
Houston
Administration
4.
987654321
1995-01-01
4.
Stafford
Headquarters
1.
888665555
1981-06-19
5
Bellaire
Sugarland
5
Houston
WORKS ON
PROJECT
Essn
Pno
Hours
Pname
Prumber
Plocation
Dnum
123456780
32.5
ProductX
1.
Belaire
Sugarland
3.
123456789
2.
7.5
ProductY
666884444
40.0
Productz
Houston
453453453
20.0
Computorization
10
Stafford
4.
Roorganization
Nowbenefits
453453453
20.0
20
Houston
1.
333445555
2.
10.0
30
Stafford
4.
333445555
3.
10.0
333445555
10
10.0
DEPENDENT
333445555
20
100
Essn
Dependent name
Sex
Bdate
Rolationship
000887777
30
30.0
333445555
Alice
F
1986-04-05
Daughter
000887777
1983-10-25
Son
333445555
333445555
10
10.0
Theodore
087987987
10
35.0
Joy
F.
1958-05-03
Spouse
087987987
M.
1042-02-28
Spouse
30
5.0
087654321
Abner
30
20.0
123456780
Michaol
1968 -01-04
Son
087654321
087654321
15.0
123456780
Alice
F
1088-12-30
Daughter
20
888665555
Elabeth
F
1967-05-05
Spouse
20
NULL
123456789
2020-2021 Facty of Information Technology (FIT), Applied Science Private University, Amman, Jordan.
KAV
Transcribed Image Text:EMPLOYEE Fnamo Minit Lname Ssn Bdato Ser Salary Address Super ssn Dno 123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555 333445555 1055-12-08 638 Voss, Houston, TX John Smith Franklin Wong M 40000 888665555 Alicia Zolaya 999887777 1968-01-19 3321 Castle, Spring, TX 25000 987654321 4. Jonnifor S Wallace 987654321 1941-06-20 291 Borry, Bollairo, TX F 43000 B88665555 4. Narayan 666884444 1962-09-15 075 Fire Oak, Humblo, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX Ramesh Joyce 25000 333445555 Ahmad Jabbar 987987987 1960-03-20 980 Dalas, Houston, TX M 25000 087654321 4. James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 1 DEPARTMENT DEPT LOCATIONS Dnamo Dnumber Mgr ssn Mgr start date Dnumbor Dlocation Rosearch 333445555 1988-05-22 Houston Administration 4. 987654321 1995-01-01 4. Stafford Headquarters 1. 888665555 1981-06-19 5 Bellaire Sugarland 5 Houston WORKS ON PROJECT Essn Pno Hours Pname Prumber Plocation Dnum 123456780 32.5 ProductX 1. Belaire Sugarland 3. 123456789 2. 7.5 ProductY 666884444 40.0 Productz Houston 453453453 20.0 Computorization 10 Stafford 4. Roorganization Nowbenefits 453453453 20.0 20 Houston 1. 333445555 2. 10.0 30 Stafford 4. 333445555 3. 10.0 333445555 10 10.0 DEPENDENT 333445555 20 100 Essn Dependent name Sex Bdate Rolationship 000887777 30 30.0 333445555 Alice F 1986-04-05 Daughter 000887777 1983-10-25 Son 333445555 333445555 10 10.0 Theodore 087987987 10 35.0 Joy F. 1958-05-03 Spouse 087987987 M. 1042-02-28 Spouse 30 5.0 087654321 Abner 30 20.0 123456780 Michaol 1968 -01-04 Son 087654321 087654321 15.0 123456780 Alice F 1088-12-30 Daughter 20 888665555 Elabeth F 1967-05-05 Spouse 20 NULL 123456789 2020-2021 Facty of Information Technology (FIT), Applied Science Private University, Amman, Jordan. KAV
Consider the database whose database state shown in appendix and answer the following question
1. Retrieve the department number and the average salary for each department for department 5 and
department 4.
Transcribed Image Text:Consider the database whose database state shown in appendix and answer the following question 1. Retrieve the department number and the average salary for each department for department 5 and department 4.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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…
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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY