Given the relation COMPENSATION as shown in Table 1, let P: SALARY < 80,000 and P2: SALARY > 80, 000 be two simple predicates. (a) Perform a horizontal fragmentation of relation COMPENSATION with respect to predicates 3 (P1, P2). Show the resultant fragments. (b) Explain why the resulting fragmentation (COMPENSATION, COMPENSATION} does not fulfill the 2 correctness rules of fragmentation. (c) Modify the predicates p and p2 so that they partition the COMPENSATION relation obeying 3 the correctness rules of fragmentation. Show the resultant fragments. Homework 1 - CS 472/572 COMPENSATION TITLE DEPT Programmer Maps Supervisor Maps Sr. Analyst Web 80,000 Analyst Web 65,000 Manager Maps 92,000 Admin Enterprise 102,000 Engineer Enterprise 88,000 Table 1: COMPENSATION relation SALARY 75,000 68,000 Page 2 of 4