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 who perform horizontal fragmentation over Employee derived from Department and a semi-join on HoD.

Answer rating: 100% (QA)

SELECT FROM Department WHERE LOCATI... View the full answer