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.
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...
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F1c9eb336-08df-4ff7-8c94-36561f1bda1a%2F05a942ce-7841-4f1b-a4bb-d8e45bea8f3d%2F4o0n4ag_processed.png&w=3840&q=75)
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY