Consider applications “Q1”, “Q2”, “Q3”, and “Q4” as shown. These applications work on thetable STUDENTS defined as “STUDENTS (RNO, NAME, ADDRESS, SEM, MARKS),” whereRNO is the primary key column of...

Consider applications “Q1”, “Q2”, “Q3”, and “Q4” as shown. These applications work on thetable STUDENTS defined as “STUDENTS (RNO, NAME, ADDRESS, SEM, MARKS),” whereRNO 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 matrixCalculate usage matrix, Attribute affinity matrix, and Clustered affinity matrix?

Dec 10, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here