Suppose you have the following relational DB. You may assume that no future instances of  the   relations will violate the keys that can be inferred to hold in the current instance : Generate relational Algebra queries for the following queries. List names of all male employees born after 1981. List EmpNo and name of each of the female managers. List all cities in which projects are located and housing employees.

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
100%

    Suppose you have the following relational DB. You may assume that no future instances of  the

  relations will violate the keys that can be inferred to hold in the current instance :

Generate relational Algebra queries for the following queries.

  • List names of all male employees born after 1981.
  • List EmpNo and name of each of the female managers.
  • List all cities in which projects are located and housing employees.
  • List EmpNo and name of married employees.
  • List EmpNo of employees who don’t work on any projects.
DataBaseMid2021-2.doc [Compatibility Mode] - Word
Sign in
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
O Tell me what you want to do
& Share
X Cut
P Find -
Times New Ro
12
-A A
Aa -
AaBbCcl AaBbC AaBbC AaBbCc AaBbCcI AaBbCc]
ab. Replace
A Select
EE Copy
Paste
в IU-abe X, X*
A - aly ,
Emphasis T Heading 1 T Heading 2 T Heading 3 1 Normal
Strong
Format Painter
Clipboard
Font
Paragraph
Styles
Editing
Emplovee :
EmpNo Ename YOB
Empl
Emp2
Emp3
Emp4
Emp5
City
Sex
DeptNo
Ali
1966
Gaza
M
D5
Sami
1975
Rafa
M
D5
Ali
1981
Gaza
M
D4
Kan Yunes
Rafa
Reem
1988
F
D4
Mona
1981
F
D1
Dependent :
EmpNo DependName Sex
Emp1
Empl
Empl
Emp5
Department :
YOB
Relationship
DeptName
Headquarters
Administration
MgrNo
Emp5
Emp3
Empl
DeptNo
Sameer
M
2000
Son
D1
Salma
Daughter
Spouse
Spouse
F
2001
D4
Lina
F
1977
D5
Research
Sameer
M
1977
Project :
WorksOn :
ProjNo PName
ProjectX
ProjectY
ProjectZ
City
EmpNo
Empl
Emp2
Empl
Emp3
Emp2
DeptNo
ProjNo
Hours
P1
Gaza
D1
P1
20
P2
Gaza
D4
P1
15
P3
Rafa
D1
P2
17
P3
15
P3
44
Page 4 of 5
743 words
English (United States)
110%
5:32 PM
O Type here to search
A d>
G ENG
04/06/2021
Transcribed Image Text:DataBaseMid2021-2.doc [Compatibility Mode] - Word Sign in File Home Insert Design Layout References Mailings Review View Help O Tell me what you want to do & Share X Cut P Find - Times New Ro 12 -A A Aa - AaBbCcl AaBbC AaBbC AaBbCc AaBbCcI AaBbCc] ab. Replace A Select EE Copy Paste в IU-abe X, X* A - aly , Emphasis T Heading 1 T Heading 2 T Heading 3 1 Normal Strong Format Painter Clipboard Font Paragraph Styles Editing Emplovee : EmpNo Ename YOB Empl Emp2 Emp3 Emp4 Emp5 City Sex DeptNo Ali 1966 Gaza M D5 Sami 1975 Rafa M D5 Ali 1981 Gaza M D4 Kan Yunes Rafa Reem 1988 F D4 Mona 1981 F D1 Dependent : EmpNo DependName Sex Emp1 Empl Empl Emp5 Department : YOB Relationship DeptName Headquarters Administration MgrNo Emp5 Emp3 Empl DeptNo Sameer M 2000 Son D1 Salma Daughter Spouse Spouse F 2001 D4 Lina F 1977 D5 Research Sameer M 1977 Project : WorksOn : ProjNo PName ProjectX ProjectY ProjectZ City EmpNo Empl Emp2 Empl Emp3 Emp2 DeptNo ProjNo Hours P1 Gaza D1 P1 20 P2 Gaza D4 P1 15 P3 Rafa D1 P2 17 P3 15 P3 44 Page 4 of 5 743 words English (United States) 110% 5:32 PM O Type here to search A d> G ENG 04/06/2021
Expert Solution
steps

Step by step

Solved in 3 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