(a) Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductY' project. (b) List the names of employees who have a dependent with the same first name as themselves. (c) Find the names of employees that are directly supervised by James Borg'. (d) For each project, list the project name and the minimum hours per week (by all employees) spent on that project. (e) Retrieve the names of employees who work on every project. (Hint: Division function can be used. You can create a Proj Emp relation with attribute of Pno and SSN, which describe the work on relation between employee and project. Divide it by a Proj(Pno) relation).
(a) Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductY' project. (b) List the names of employees who have a dependent with the same first name as themselves. (c) Find the names of employees that are directly supervised by James Borg'. (d) For each project, list the project name and the minimum hours per week (by all employees) spent on that project. (e) Retrieve the names of employees who work on every project. (Hint: Division function can be used. You can create a Proj Emp relation with attribute of Pno and SSN, which describe the work on relation between employee and project. Divide it by a Proj(Pno) relation).
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
DATABSE
Transcribed Image Text:(a) Retrieve the names of employees in department 5 who work more than 10 hours per week on
the 'ProductY project.
(b) List the names of employees who have a dependent with the same first name as themselves.
(c) Find the names of employees that are directly supervised by James Borg'.
(d) For each project, list the project name and the minimum hours per week (by all
employees) spent on that project.
(e) Retrieve the names of employees who work on every project. (Hint: Division function can be
used. You can create a Proj Emp relation with attribute of Pno and SSN, which describe the work
on relation between employee and project. Divide it by a Proj(Pno) relation).
Transcribed Image Text:. Specify relational algebra expressions for the following descriptions on the database
schema shown in Figure 5.6 using the relational operators discussed in this chapter.
Figure 5.6
One possible database state for the COMPANY relational database schema
ΕMPLOYE Ε
Minit Lname
Sex Salary Super_een Dno
123456780 1965-01-00 731 Fondren, Houston, TX M 30000 333445555
M 40000 88665555
25000 987654321
43000 888665555
Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555
25000 333445555
M 25000 087654321
Fname
Sen
Bdate
Address
John
B
Smith
5
333445555 1965-12-08 638 Voes, Houston, TX
Zelaya 999887777 1968-01-19 3321 Castle, Spring. TX
Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX
Franklin
Wong
Alicia
4
Jennifer
F
4
Ramesh
K
English 453453453 1972-07-31 5631 Rice, Houston, TX
987987987 1969-03-29 980 Dalas, Houston, TX
888665555 1937-11-10 450 Stone, Houston, TX
Joyce
A
F
5
Ahmad
V
Jabbar
4
James
E
Borg
M 55000 NULL
DEPARTMENT
DEPT LOCATIONS
Dname
Dnumber
Mg san
Mgr_start date
Dnumber
Dlocation
Research
333445555
1988-05-22
1
Houston
Administration
4
987654321
1995-01-01
4
Stafford
Headquarters
888665555
1981-06-19
5
Bellaire
5
Sugarland
5
Houston
WORKS ON
PROJECT
Essn
Pno
Hours
Prame
Pnumber
Plocation
Dnum
123456789
1
32.5
ProductX
Bellaire
123456789
ProductY
Sugarland
2
7.5
2
666884444
3
40.0
Productz
Houston
5
453453453
20.0
Computerization
10
Stafford
4
453453453
2
20.0
Reorganization
20
Houston
1
333445555
10.0
Newbenefits
30
Stafford
333445555
3
10.0
333445555
10
10.0
DEPENDENT
333445555
20
10.0
Enan
Dependent name
Sex
Bdate
Relationship
999887777
30
30.0
1986-04-05 Daughter
1083-10-25 Son
1958-05-03 Spouse
1942-02-28 Spouse
333445555
Alice
999887777
10
10.0
333445555
Theodore
M
987987987
10
35.0
333445555
Joy
F
987987987
30
5.0
987054321
Abner
M
987654321
30
20.0
123456789
Michael
M
1988-01-04
Son
987654321
20
15.0
Alice
F
Daughter
Spouse
123456789
1988-12-30
888665555
20
NULL
123456789
Elizabeth
F
1967-05-05
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
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