As in section 18.2.3 we assume the secondary index on MGRSSN of DEPARTMENT, with selection cardinality s=1 and level x=1

[answerhappygod]

As in section 18.2.3 we assume the secondary index on MGRSSN of
DEPARTMENT, with selection cardinality s=1 and level x=1;
Using Method J1 with EMPLOYEE as outer loop:
J1 with DEPARTMENT as outer loop:
J2 with EMPLOYEE as outer loop, and MGRSSN as secondary key for
S:
J2 with DEPARTMENT as outer loop: