EMPLOYEE FNAME MINIT LNAME
SSN
John
B
Smith
Franklin
T
Wong
Alicia
J
Zelaya
999887777
Jennifer
S
Wallace
987654321
BDATE
123456789 1965-01-09
333445555 1955-12-08
1968-07-19
1941-06-20
ADDRESS
731 Fondren, Houston, TX
638 Voss, Houston, TX
SEX
SALARY
SUPERSSN DNO
3321 Castle, Spring, TX
291 Berry, Bellaire, TX
MMF
30000
40000
333445565
888665555 5
5
25000
987654321
4
F
43000
888666555 4
Ramesh
K
Narayan
666884444
1962-09-15
975 Fire Oak, Humble, TX
M
38000
333445656 5
Joyce
A
English
453453453
1972-07-31
5631 Rice, Houston, TX
F
25000
333445555
5
Ahmad
V
Jabbar
James
E
Borg
967967987
888665555
1969-03-29
980 Dallas, Houston, TX
M
25000
987654321
4
1937-11-10
450 Stone, Houston, TX
M
55000
null
1
DEPT LOCATIONS
DNUMBER
DLOCATION
1
Houston
4
Stafford
DEPARTMENT
DNAME
DNUMBER
MGRSSN
MGRSTARTDATE
5
Bellaire
Research
5
333445555
1968-05-22
5
Sugarland
Administration
43
987654321
Headquarters
888665555
1995-01-01
1961-06-19
5
Houston
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
1
Bellaire
5
333445555
3
10.0
ProductY
2
Sugarland
5
333445555
10
3303445555
20
999887777
30
888
10.0
Product
3
Houston
5
10.0
30.0
999887777
10
10.0
Computerization
Reorganization
Newbenefits
10
Stafford
4
20
Houston
1
THE
30
Stafford
4
967987987
10
35.0
967987987
30
987654321
30
987654321
888665555
20
20
8888
5.0
20.0
15.0
nul
DEPENDENT
ESSN
333445555
DEPENDENT NAME SEX
BDATE
RELATIONSHIP
Alice
F
1986-04-05
DAUGHTER
333445555
Theodore
M
131
1983-10-25
SON
333445555
Joy
F
1968-05-03
987654321
Abner
M
1942-02-28
SPOUSE
SPOUSE
123456789
Michael
M
1968-01-04
SON
123456789
Alce
F
1968-12-30
123456789
Elizabeth
F
1967-06-05
DAUGHTER
SPOUSE
Specify the following queries on the database schema shown in above Figure using the relational
algebra discussed in class.
1. Find name of projects controlled by department 5
2. Find the names of male employees that works for 'Research' department
3 List department locations for department Research