Consider applications “Q1”, “Q2”, “Q3”, and “Q4” as shown. These applications work on the
table STUDENTS defined as “STUDENTS (RNO, NAME, ADDRESS, SEM, MARKS),” where
RNO is the primary key column of the table.
Q1: Select NAME from STUDENTS where MARKS = 100;
Q2: Select MARKS from STUDENTS;
Q3: Select SEM from STUDENTS where ADDRESS = ‘RWP’;
Q4: Select NAME from STUDENTS where SEM = 6;
Perform vertical fragmentation?
frequency matrix
Calculate usage matrix, Attribute affinity matrix, and Clustered affinity matrix?
Extracted text: Consider applications "Ql", “Q2", “Q3", and “Q4" as shown. These applications work on the table STUDENTS defined as "STUDENTS (RNO, NAME, ADDRESS, SEM, MARKS)," where RNO is the primary key column of the table. Ql: Select NAME from STUDENTS where MARKS = 100; Q2: Select MARKS from STUDENTS; Q3: Select SEM from STUDENTS where ADDRESS = 'RWP'; Q4: Select NAME from STUDENTS where SEM = 6; %3D Perform vertical fragmentation? SI QI Q2 Q3 Q4 frequency matrix S2 S3 S4 4 3 4 3 Calculate usage matrix, Attribute affinity matrix, and Clustered affinity matrix?