Question: You must answer the queries using relational algebra. Answer them in any other ways, such as SQL , will get a 0 . ( 1

You must answer the queries using relational algebra. Answer them in any other ways, such as SQL, will get a 0.
(1) Retrieve the names (fname,Iname) of all employees who do not work on any project.
(2) Retrieve the names (fname,Iname) of employees who work more than 9 hours per week on the 'ABC' project.
("ABC" is project name.)
(3) Retrieve the department (dname) that has a location in 'Denver'.
(4) Find the names (fname,Iname) of employees who are directly supervised by 'Steven Miller'.
 You must answer the queries using relational algebra. Answer them in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!