A DDBMS was fragmented into 3 sites as follows:

Site 1 had the employee table (ssn, address, salary, dept_id); 

Site 2 had the project table (proj_id, proj_name, location);

Site 3 had the department table (dept_id, department_name, phone).   

If the query below is placed at site 2, describe the 3 possible options that the optimizer might consider for

distributed query processing.

Select ssn, address, department_name from employee, department where employee.dept_id =   department.dept_id