subject: Distributed database

3. (a) Let Q = {91,92,93,94,95) be a set of queries, A = {A1,A2,A3,A4,A5) be 10 points a set of attributes, and S = {S1,S2,S3) be a set of sites. The matrix of Figure 3a describes the attribute usage values and the matrix of Figure 3b gives the application access frequencies. Assume that refi(qk) = 1 for all qk and Si and that A1 is the key attribute. Now calculate AA matrix and suppose A1, A4 already placed in CA matrix, now place A2 using bond energy algorithm. (b) Create view SOFT (ID. Name) who are involved in Software Projects. * Now calculate AA matrix and suppose A1, A4 already placed in CA matrix, now place A2 using bond energy algorithm. 7 0 1 1 0 1 10 20 . 1 5010 0 0 1 1 . 0355 0 0 1 0 10 0100 0 150 0 Figure: 3a Figure: 36 (b) Create view SOFT (ID. Name) who are involved in Software Projects. STD ID STD Name Department SI PXY CSE S2 OXY Physics S3 RXY EEE S4 SXY CSE S5 TXY EEE S6 UXY Physics Table 1: STUDENT Table STD ID Project ID Title SI P1 Software Eng S2 P2 Embedded Systems S2 P3 Electronics S3 P4 Electronics SS PS Embedded Systems S5 P6 Software Developing Table 2: PROJECT Table 3. (a) Let Q = {91,92,93,94,95) be a set of queries, A = {A1,A2,A3,A4,A5) be 10 points a set of attributes, and S = {S1,S2,S3) be a set of sites. The matrix of Figure 3a describes the attribute usage values and the matrix of Figure 3b gives the application access frequencies. Assume that refi(qk) = 1 for all qk and Si and that A1 is the key attribute. Now calculate AA matrix and suppose A1, A4 already placed in CA matrix, now place A2 using bond energy algorithm. (b) Create view SOFT (ID. Name) who are involved in Software Projects. * Now calculate AA matrix and suppose A1, A4 already placed in CA matrix, now place A2 using bond energy algorithm. 7 0 1 1 0 1 10 20 . 1 5010 0 0 1 1 . 0355 0 0 1 0 10 0100 0 150 0 Figure: 3a Figure: 36 (b) Create view SOFT (ID. Name) who are involved in Software Projects. STD ID STD Name Department SI PXY CSE S2 OXY Physics S3 RXY EEE S4 SXY CSE S5 TXY EEE S6 UXY Physics Table 1: STUDENT Table STD ID Project ID Title SI P1 Software Eng S2 P2 Embedded Systems S2 P3 Electronics S3 P4 Electronics SS PS Embedded Systems S5 P6 Software Developing Table 2: PROJECT Table