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:

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
Get step-by-step solutions from verified subject matter experts
