Q.2) Consider queries Q1, Q2, Q3, Q4 given below. These queries work on table defined as PROJ(PNO,
PNAME, BUDGET, LOC) where PNO is primary key column of table.
Calculate 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
Q3 = SELECT PNO FROM PROJ WHERE LOC = Value
Q4 = SELECT SUM(BUDGET) FROM PROJ
S1 S2 S3 S4
Q1 1 0 2 10
Q2 0 4 3 20
Q3 0 0 4 30
Q4 3 0 0 0