QUESTION 1: Consider 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.
QUESTION 1: Consider 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.
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
Related questions
Question
Transcribed Image Text:QUESTION 1:
Consider 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:Appendix
EMPLOYEE
Fnamo
Minit
Lname
Ssn
Bdato
Addross
Ser Salary
Super ssn Dno
123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555
333445555 1955-12-08 638 Voss, Houston, TX
John
B
Smith
Franklin
Wong
40000 888665555
25000 987654321
999887777 1968-01-10 3321 Castlo, Spring, TX
Wallaco 987654321 1941-06-20 201 Borry, Bollaire, TX
Alicia
Zolaya
4.
Jonnifor
43000 888665555
4.
Narayan 666884444 1962-09-15 975 Fire Oak, Humblo, TX M 38000 333445555
English 453453453 1972-07-31 5631 Rice, Houston, TX
Ramosh
K
Joyce
25000 333445555
Ahmad
V
Jabbar
987987987 1969-03-20 980 Dalas, Houston, TX
M 25000 087654321
4.
James
Borg
888665555 1937-11-10 450 Stono, Houston, TX
M 55000 NULL
DEPARTMENT
DEPT LOCATIONS
Dnamo
Dnumber
Mgr ssn
Mgr start date
Dnumbor
Dlocation
Rosearch
333445555
1988-05-22
Houston
Administration
4.
987654321
1995-01-01
Stafford
Headquarters
1.
888665555
1981-06-19
5.
Bellaire
5.
Sugarland
Houston
WORKS ON
PROJECT
Essn
Pno
Hours
Pname
Prumber
Plocation
Dnum
123456789
32.5
ProductX
Belaire
123456789
7.5
ProductY
2.
Sugarland
5.
666884444
40.0
ProductZ
Houston
453453453
20.0
Computorization
10
Stafford
4.
453453453
2.
20.0
Roorganization
20
Houston
1.
333445555
10.0
Nowbenefits
30
Stafford
4.
333445555
3.
10.0
333445555
10
10.0
DEPENDENT
333445555
20
10.0
Essn
Dependent name
Sox
Rolationship
Bdato
909887777
30
30.0
333445555
Alice
1986-04-05
Daughter
000887777
10
10.0
333445555
Theodoro
1983-10-25
Son
087087987
10
35.0
1958-05-03 Spouse
Spouse
333445555
Joy
087087987
30
5.0
987654321
Abnor
1942-02-28
087654321
30
20.0
123456780
Michaol
M.
1988-01-04
Son
087654321
20
15.0
123456789
Alice
1988-12-30
Daughter
888665555
20
NULL
123456789
Eizaboth
F
1967-05-05
Spouse
92020-2021 Faculty of Information Technology (FIT), Applied Science Private University, Amman, Jordan.
2
Expert Solution
Step 1
1.
SELECT command is used to retrieve the data from the table.
We need to retrieve first name and last name of the employee as Name who works in Research department
Step by step
Solved in 2 steps
Knowledge Booster
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
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education