Question

Answer 5.2 & 5.3
Please frnds...i hv mahh IT xam tmrw...#class 10th

Answer 1

5.2 answer will be (1) roll number, type varchar() (2) admission number numeric (3) name , type char() (4) date of birth varchar () (5) class char() Primary key should be roll number because roll number of every student is unique it will give fast query results

Answer 2

5.2 Primary key would be Admission no.Because it will be unique for each  student.if we take roll no as an primary key then in each class roll no will same.so we can't take it as primary key.

5.3 Filtering of data means we extract or display record based on some condition.
e.g. consider the below table.
   Id    Name  Salary
   1      xyz      1000
   2      abc      2500
   3      fgh       3000
if we filter and display only the data whose salary is less than 3000.then it will print only two record(1st and 2nd).It is called filtering.

Sorting:sort the data in ascending or descending order of an attribute.
e.g. sort the data in descending order based on salary then output will be
  Id    Name  Salary
   3      fgh       3000
   2      abc      2500
    1      xyz      1000