Answer to Question #44389 in Databases | SQL | Oracle | MS Access for moses

Question #44389
Consider the relations EMPLOYEE(emp#, name) 5+5 10 ASSIGNED_TO(project#, emp#) PROJECT(project#, project_name, chief) Express the following queries in Relational Algebra (i) Get details of employee working on both comp354 and comp345 project numbers. (ii)Find the employee number of employee who do not work on project comp678
1
Expert's answer
2014-07-24T08:46:43-0400
Consider the relations
EMPLOYEE(emp#, name)
5+5
10
ASSIGNED_TO(project#, emp#)
PROJECT(project#, project_name, chief)
Express the following queries in Relational Algebra
(i) Get details of employee working on both comp354 and comp345 project
numbers.
(ii)Find the employee number of employee who do not work on project
comp678
Ans:(i) EMPLOYEE (ASSIGNED TO project # (σ(project#=’comp351’ ∨ project#=’comp 345 ASSIGNED _TO)))
Ans: (ii) TEmp#(EMPLOYEE)-TEmp#(project#=’c 678’ ASSIGNED_TO))

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS