60 370
Assignments Done
98,1%
Successfully Done
In April 2018

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
Expert's answer
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

Submit
Privacy policy Terms and Conditions