EMPLOYEE Fname Minit Lname Sex Salary S Address 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 35 Ssn Bdate John B Smith 333445555 1955-12-08 638 Voss, Houston, TX 999887777 1968-01-19 3321 Castle, Spring, TX S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 35 English 453453453 1972-07-31 5631 Rice, Houston, TX 987987987 1969-03-29 980 Dallas, Houston, TX Franklin T Wong M 40000 88 F 25000 98 F 43000 8 Alicia Zelaya Jennifer Ramesh K Joyce A F 25000 33 Ahmad V Jabbar M 25000 98

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
Consider the relational database given in Figure 01 and answer the below questions.
Figure 01
EMPLOYEE
Fname
Sex Salary Super_ssn Dno
Minit Lname
B Smith
T Wong
Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX
Wallace 987654321 1941-06-20 |291 Berry, Bellaire, TX
Ssn
Bdate
Address
123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555
M 40000 888665555
F 25000 987654321
F 43000 888665555
John
333445555 1955-12-08 638 Voss, Houston, TX
Franklin
Alicia
4
Jennifer
S
4
Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555
F 25000 333445555
V Jabbar 987987987 1969-03-29 980 Dalas, Houston, TX M 2500o 987654321
888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL
Ramesh K
Joyce
A
English 453453453 1972-07-31 5631 Rice, Houston, TX
5
Ahmad
4
James
E Borg
a) By Using Relational Algebra Concepts find the First name and Birth date of the
employees who are working in Department no 4 and making salary over than
40000.Also write the output table.
b) By Using Relational algebra find list of all fmale employees whose salary is equal or
greater than 20000. Also write the output table.
c) To retrieve the social security numbers of all employees who either work in department
5 or directly supervise an employee who works in department 4. Also write the output
table.
Transcribed Image Text:Consider the relational database given in Figure 01 and answer the below questions. Figure 01 EMPLOYEE Fname Sex Salary Super_ssn Dno Minit Lname B Smith T Wong Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX Wallace 987654321 1941-06-20 |291 Berry, Bellaire, TX Ssn Bdate Address 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 M 40000 888665555 F 25000 987654321 F 43000 888665555 John 333445555 1955-12-08 638 Voss, Houston, TX Franklin Alicia 4 Jennifer S 4 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 F 25000 333445555 V Jabbar 987987987 1969-03-29 980 Dalas, Houston, TX M 2500o 987654321 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL Ramesh K Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX 5 Ahmad 4 James E Borg a) By Using Relational Algebra Concepts find the First name and Birth date of the employees who are working in Department no 4 and making salary over than 40000.Also write the output table. b) By Using Relational algebra find list of all fmale employees whose salary is equal or greater than 20000. Also write the output table. c) To retrieve the social security numbers of all employees who either work in department 5 or directly supervise an employee who works in department 4. Also write the output table.
Expert Solution
trending now

Trending now

This is a popular 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