Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
1. Retrieve the name of all employees who work in "Research" Department.

1. Retrieve the name of all employees who work in "Research" Department.

C++ for Engineers and Scientists
C++ for Engineers and Scientists
4th Edition
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Bronson, Gary J.
Chapter1: Fundamentals Of C++ Programming
Section1.4: Preliminary Four: Algorithms
Problem 1E: (Practice) Determine a step-by-step procedure (list the steps) to do the following tasks: a. Fix a...
See similar textbooks
icon
Related questions
Question
QUESTION 1: onsider the database whose database state shown in appendix and answer the following questions: 1. Retrieve the name of all employees who work in "Research" Department.
Transcribed Image Text:QUESTION 1: onsider the database whose database state shown in appendix and answer the following questions: 1. Retrieve the name of all employees who work in "Research" Department.
ΕMPLOYEΕ Ssn Bdato Address Ser Salary Super ssn Dno Fnamo Minit Lname 123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555 M 40000 B88665555 John Smith Wong 333445555 1055-12-08 638 Voss, Houston, TX Franklin 999887777 1968-01-19 3321 Castlo, Spring, TX F 25000 987654321 4. Zolaya Wallace 987654321 1941-06-20 291 Borry, Bollairo, TX Alicia 43000 888665555 4. Jonnifor Narayan 666884444 1962-09-15 975 Fire Oak, Humblo, TX M 38000 333445555 25000 333445555 M 25000 087654321 Ramesh K. English 453453453 1972-07-31 5631 Rice, Houston, TX 987987987 1969-03-20 980 Dallas, Houston, TX Joyce 4. Ahmad Jabbar James Borg 888665555 1937-11-10 450 Stono, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dname Dnumber Mgr ssn Mgr start dato Dnumbor Dlocation Rosearch 333445555 1988-05-22 1. Houston Administration 4. 987654321 1995-01-01 4. Stafford Headquarters 1 888665555 1981-06-19 5 Bellaire Sugarland Houston WORKS ON PROJECT Essn Pno Hours Pname Prumber Plocation Dnum 123456789 32.5 ProductX 1. Belaire 123456789 75 ProductY Sugarland 666884444 3 40.0 ProductZ Houston 5. 453453453 20.0 Computorization 10 Stafford 4. 453453453 20.0 Roorganization 20 Houston 333445555 2. 10.0 Nowbenefits 30 Stafford 4. 333445555 333445555 3. 10.0 10 10.0 DEPENDENT 333445555 20 10.0 Essn Dependent name Sex Rolationship 1986-04-05 Daughter Bdato 009887777 30 30.0 333445555 Alice F 000887777 10 10.0 333445555 Theodore M 1983-10-25 Son 987987987 087987987 10 35.0 333445555 Joy 1958-05-03 Spouse 30 5.0 087654321 Abnor 987654321 1942-02-28 Spouse 30 20.0 123456780 Michaol 087654321 20 1988-01-04 Son 15.0 123456780 Alice 888665555 1988-12-30 Daughter 20 NULL 123456789 Ekzaboth F 1967-05-05 Spouse 2020-2021 Facuty of Information Technology (FIT), Applied Science Private University, Amman, Jordan.
Transcribed Image Text:ΕMPLOYEΕ Ssn Bdato Address Ser Salary Super ssn Dno Fnamo Minit Lname 123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555 M 40000 B88665555 John Smith Wong 333445555 1055-12-08 638 Voss, Houston, TX Franklin 999887777 1968-01-19 3321 Castlo, Spring, TX F 25000 987654321 4. Zolaya Wallace 987654321 1941-06-20 291 Borry, Bollairo, TX Alicia 43000 888665555 4. Jonnifor Narayan 666884444 1962-09-15 975 Fire Oak, Humblo, TX M 38000 333445555 25000 333445555 M 25000 087654321 Ramesh K. English 453453453 1972-07-31 5631 Rice, Houston, TX 987987987 1969-03-20 980 Dallas, Houston, TX Joyce 4. Ahmad Jabbar James Borg 888665555 1937-11-10 450 Stono, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dname Dnumber Mgr ssn Mgr start dato Dnumbor Dlocation Rosearch 333445555 1988-05-22 1. Houston Administration 4. 987654321 1995-01-01 4. Stafford Headquarters 1 888665555 1981-06-19 5 Bellaire Sugarland Houston WORKS ON PROJECT Essn Pno Hours Pname Prumber Plocation Dnum 123456789 32.5 ProductX 1. Belaire 123456789 75 ProductY Sugarland 666884444 3 40.0 ProductZ Houston 5. 453453453 20.0 Computorization 10 Stafford 4. 453453453 20.0 Roorganization 20 Houston 333445555 2. 10.0 Nowbenefits 30 Stafford 4. 333445555 333445555 3. 10.0 10 10.0 DEPENDENT 333445555 20 10.0 Essn Dependent name Sex Rolationship 1986-04-05 Daughter Bdato 009887777 30 30.0 333445555 Alice F 000887777 10 10.0 333445555 Theodore M 1983-10-25 Son 987987987 087987987 10 35.0 333445555 Joy 1958-05-03 Spouse 30 5.0 087654321 Abnor 987654321 1942-02-28 Spouse 30 20.0 123456780 Michaol 087654321 20 1988-01-04 Son 15.0 123456780 Alice 888665555 1988-12-30 Daughter 20 NULL 123456789 Ekzaboth F 1967-05-05 Spouse 2020-2021 Facuty of Information Technology (FIT), Applied Science Private University, Amman, Jordan.
Expert Solution
Step 1

Query to retrieve the name of all employees who work in research department.

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Single Table
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.
Recommended textbooks for you
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Security (MindTap Cours…
Principles of Information Security (MindTap Cours…
Computer Science
ISBN:
9781337102063
Author:
Michael E. Whitman, Herbert J. Mattord
Publisher:
Cengage Learning
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
A+ Guide To It Technical Support
A+ Guide To It Technical Support
Computer Science
ISBN:
9780357108291
Author:
ANDREWS, Jean.
Publisher:
Cengage,
SEE MORE TEXTBOOKS