distributed database - Derive the primary horizontal fragmentation of ASG using the foregoing information?

Question

Consider relation ASG in Figure 3.3. Suppose there are two applications that access ASG. The first is issued at five sites and attempts to find the duration of assignment of employees given their numbers. Assume that managers, consultants, engineers, and programmers are located at four different sites. The second application is issued at two sites where the employees with an assignment duration of less than 20 months are managed at one site, whereas those with a longer duration are managed at a second site. Derive the primary horizontal fragmentation of ASG using the foregoing information

Answer 1

等待大神答复