Consider the relation EMP in Figure below. Suppose there is one application that access EMP. It is using TITLE in EMP included in its simple predicates. 1) Find all possible simple predicates for TITLE in EMP. 2) Derive the primary horizontal fragmentation of EMP using the simple predicates in 1). 3) Using the fragmentation of EMP in 2), perform a derived horizontal fragmentation for ASG.

1. Consider the relation EMP in Figure below. Suppose there is one application that access EMP. It is using 'TITLE' in EMP included in its simple predicates. 1) Find all possible simple predicates for 'TITLE' in EMP. 2) Derive the primary horizontal fragmentation of EMP using the simple predicates in 1). 3) Using the fragmentation of EMP in 2), perform a derived horizontal fragmentation for ASG