Consider queries Q1, Q2, Q3, Q4 given below. These queries work on a table defined as PROJ (PNO, PNAME, BUDGET, LOC) where PNO is the primary key column of the table. Calculate the attribute usage matrix.
Consider the following relation PROJ (PNO, PNAME, BUDGET, LOC) and the following queries. Access frequency is also given.
Q1 = SELECT PNAME FROM PROJ WHERE PNO = Value
Q2 = SELECT PNAME, BUDGET FROM PROJ
S1 = 1 0 0 3
S2 = 0 T
S3 = 2
Q1 = 0 2 0 3
Q4 = 10 20 30 0
Q3 = SELECT PNO FROM PROJ WHERE LOC = Value
Q4 = SELECT SUM(BUDGET) FROM PROJ
0