consider another query Q$$: For each department, retrieve the department

name and the department manager's name.

This can be stated as follows in the relational algebra:

Fname$,$Lname,Dname$($DEPARTMENT $$Mgr$\_$ssn$=$Ssn EMPLOYEE$)$

Again, suppose that the query is submitted at site $3.$ The same three strategies for

executing query Q apply to Q$,$ except that the result of Q$$ includes only $100$ records,

assuming that each department has a manager:

$1.$ Transfer both the EMPLOYEE and the DEPARTMENT relations to the result

site, and perform the join at site $3.$

$2.$ Transfer the EMPLOYEE relation to site $2,$ execute the join at site $2,$ and send

the result to site $3.$

$3.$ Transfer the DEPARTMENT relation to site $1,$ execute the join at site $1,$ and

send the result to site $3.$

Which strategy is better? Show your computations.