Name: Number: Question: Consider you have the following table distributed on these sites. 1 Site A Site B Site C Site D EMP(1000 record) PROI (100 record) (Query Site) DEPT(20 record) Assume that the join results of the tables are as follows: EMP PROJ = 100 record PROJ ADEPT = 20 record EMP W DEPT = 1000 record EMP= (EmplD (10bytes), EmpName (60byte), EmpDept (10byte), ProjD[20byte)) PROJ= (ProjlD [20byte), ProjName (30byte), DeptiD [10byte)) DEPT= (DeptiD (10byte), DeptName(40byte)) Consider all the queries issued at Site C. Find the cost of executing the following queries depending on the strategies used. from EMP, Proj where 1. Select EMP. EmpName, Proj. ProjName EMP. ProjID=Proj. ProjID a. The cost, if the query is executed at Site A based on semi join= b. The cost, if the query is executed at Site A based on full join= from EMP, Dept where 2. Select EMP.empname, EMP. Emp Dept EMP. EmpDept-Dept. DeptID; a. The cost, if the query is executed at Site A based on semi join= E b. The cost, if the query is executed at Site D based on semi join= c. The cost, if the query is executed at Site C based on semi join= from PROJ, DEPT where 3. Select PROJ. ProjID, PROJ. ProjName PROJ. DeptID=Dept. DeptID a. The cost, if the query is executed at Site B based on full join= b. The cost, if the query is executed at Site D based on full join= c. The cost, if the query is executed at Site C based on full join= Name: Number: Question: Consider you have the following table distributed on these sites. 1 Site A Site B Site C Site D EMP(1000 record) PROI (100 record) (Query Site) DEPT(20 record) Assume that the join results of the tables are as follows: EMP PROJ = 100 record PROJ ADEPT = 20 record EMP W DEPT = 1000 record EMP= (EmplD (10bytes), EmpName (60byte), EmpDept (10byte), ProjD[20byte)) PROJ= (ProjlD [20byte), ProjName (30byte), DeptiD [10byte)) DEPT= (DeptiD (10byte), DeptName(40byte)) Consider all the queries issued at Site C. Find the cost of executing the following queries depending on the strategies used. from EMP, Proj where 1. Select EMP. EmpName, Proj. ProjName EMP. ProjID=Proj. ProjID a. The cost, if the query is executed at Site A based on semi join= b. The cost, if the query is executed at Site A based on full join= from EMP, Dept where 2. Select EMP.empname, EMP. Emp Dept EMP. EmpDept-Dept. DeptID; a. The cost, if the query is executed at Site A based on semi join= E b. The cost, if the query is executed at Site D based on semi join= c. The cost, if the query is executed at Site C based on semi join= from PROJ, DEPT where 3. Select PROJ. ProjID, PROJ. ProjName PROJ. DeptID=Dept. DeptID a. The cost, if the query is executed at Site B based on full join= b. The cost, if the query is executed at Site D based on full join= c. The cost, if the query is executed at Site C based on full join=