Let's consider a generic schema with two tables:

EMPLOYEES $($EmpID$,$ EmpName, Department, Salary, ManagerID$)$

PROJECTS $($ProjectID$,$ ProjectName, Department, Budget$)$

ASSIGNMENTS $($EmpID$,$ ProjectID, HoursWorked$)$

What will be the result of the following queries written in relational algebra?

$1.\backslash$pi $\_$ProjectID, ProjectName, Budget $(\backslash$sigma $\_$Budget $>(\backslash$pi $\_$AVG$($Budget$)($PROJECTS$))$

$2.\backslash$pi $\_$EmpID, EmpName $((\backslash$sigma $\_$Department$=\text{'}$IT$\text{'}($ASSIGNMENTS $$ PROJECTS$))\backslash$cap

$(\backslash$sigma $\_$Department$=$'Finance' $($ASSIGNMENTS $$ PROJECTS$)))$

$3.$ Department, AVG$($HoursWorked$)($ASSIGNMENTS $$ PROJECTS$)|($Group by

Department$)$

$4.\backslash$pi $\_$ManagerID, EmpName $($EMPLOYEES $\backslash$rho $\_$EmpID$=$ManagerID $($EMPLOYEES$))$