Given relation EMP as in the following Figure let p1: TITLE < "Programmer" and p2: TITLE > Programmer be two simple predicates. Assume that character strings have an order among them, based on the alphabetical order.

(a) Perform a horizontal fragmentation of relation EMP with respect to {p1, p2}.

(b) Explain why the resulting fragmentation (EMP1, EMP2) does not fulfil the correctness rules of fragmentation.

(c) Modify the predicates p1 and p2 so that they partition EMP obeying the correctness rules of fragmentation. To do this, modify the predicates, compose all minterm predicates and deduce the corresponding implications, and then perform a horizontal fragmentation of EMP based on these minterm predicates.

Finally, show that the result has completeness, reconstruction, and disjointness properties.

Note: Type your answer please don't answer by handwrite.