Calculate the cost of functions for different options of executing the JOIN operation OP7. OP7: DEPARTMENT |x| MGRSSN=SS

[answerhappygod]

Calculate the cost of functions for different options of
executing the JOIN operation OP7.
OP7: DEPARTMENT |x| MGRSSN=SSN EMPLOYEE
We assume the secondary index on MGRSSN of DEPARTMENT, with
selection cardinality s=1 and level x=1.
J2 with EMPLOYEE as outer loop, and MGRSSN as secondary key for
S(index-based nested-loop join):
Please add the mgrssn as the secondary key to the
formula and solve. Thank you.