Assume you have a global relation: Student(Reg_no, Name, Course, Dept, Faculty_mentor, Address) Department(Dept, Location, HoD) Employee(Emp_no, HoD, Designation) Perform the fragmentation as follows: Horizontally Fragment Department by location, with 4 locations. For each department, there is an HoD under whom there are a number of employees. Perform horizontal fragmentation over Employee derived from Department and a semi-join on HoD.