Subject -distributed database

3. (a) Let Q = {91,92,93,94,95} 10 poi be a set of queries, A = {A1,A2,A3,A4,A5} be 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 A A A A 91 0 1 1 0 1 10 20 0 ay 1 0 1 5 010 1 0 0 1 1 0 35 5 04 0 0 1 0 0 04 010 0 Q 0 0 15 0 Figure: 3a Figure: 36 (b) Create view SOFT (ID, Name) who are involved in Software Projects. STD_ID STD Name Department S1 PXY CSE S2 QXY Physics S3 RXY EEE S4 SXY CSE S5 TXY EEE S6 UXY Physics Table 1: STUDENT Table STD ID Project ID Title S1 P1 Software Eng. S2 P2 Embedded Systems S2 P3 Electronics S3 P4 Electronics S5 P5 Embedded Systems S5 P6 Software Developing Table 2: PROJECT Table : 3. (a) Let Q = {91,92,93,94,95} 10 poi be a set of queries, A = {A1,A2,A3,A4,A5} be 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 A A A A 91 0 1 1 0 1 10 20 0 ay 1 0 1 5 010 1 0 0 1 1 0 35 5 04 0 0 1 0 0 04 010 0 Q 0 0 15 0 Figure: 3a Figure: 36 (b) Create view SOFT (ID, Name) who are involved in Software Projects. STD_ID STD Name Department S1 PXY CSE S2 QXY Physics S3 RXY EEE S4 SXY CSE S5 TXY EEE S6 UXY Physics Table 1: STUDENT Table STD ID Project ID Title S1 P1 Software Eng. S2 P2 Embedded Systems S2 P3 Electronics S3 P4 Electronics S5 P5 Embedded Systems S5 P6 Software Developing Table 2: PROJECT Table