Question: please solve question (2) last one 2) Draw the intermediate relations R1, R2 and the final RESULT relation produced by the following relational algebra expression:

 please solve question (2) last one 2) Draw the intermediate relations
please solve question (2) last one
R1, R2 and the final RESULT relation produced by the following relational
algebra expression: (3 points) R1 DEPARTMENT PROJECT Poumber:Poum Assignment\# 1 1) Using

2) Draw the intermediate relations R1, R2 and the final RESULT relation produced by the following relational algebra expression: (3 points) R1 DEPARTMENT PROJECT Poumber:Poum Assignment\# 1 1) Using the COMPANY database state, express the following queries in relational algebra: 1.1 Select all female employees. ( 0.5 point) 1.2 Select all the employees supervised by the employee whose Social Security Number (SSN) is 333445555 . ( 0.5 point) 1.3 Select all female employees that work in department 5. (0.5 point) 1.4 Select all projects controlled by department 5. ( 0.5 point) 1.5 Select the dependent name and birth date of all dependents that belong to the employee whose SSN is 333445555. (1 point) 1.6 Produce a relation showing the employee first name, last name, name of his/her dependent, dependent's birth date, and relationship to the employee. ( 1 point) 2) Draw the intermediate relations R1,R2 and the final RESULT relation produced by the following relational algebra expression: (3 points)

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!