Course Title: Distributed Database Management Systems

b) Consider relation ASG in Figure 2b. Suppose there are two applications that access ASG. The first is issued at three sites and attempts to find the duration of assignment of the employees given their numbers. Assume that managers, analysts, and programmers are located at three different sites. The second application is issued at two sites where the employees with assignment duration of less than 28 months are managed at one site, whereas those with longer duration are managed at a second site. Derive the primary horizontal fragmentation of ASG using the foregoing information. 5 Figure-2b: ASG relation