undefined

Row Class Sid# Student Name Pid# Test#1 raw Office# Professor Test#1 extra % Test#1 Total Test#1 extra credits 1 1 1 AIC 10 5 55 2 Gauss 22 2 1 2 Bob B 60 10 6 66 2 Gauss 22 3 2 CHIT 3 Cal T 70 10 77 Jay 33 4 2 4 Dan P Dan P 80 10 8 3 Jay 33 5 3 5 Ed P 10 3 Jay 33 6 3 3 Cal T 10 99 3 Jay 34 The table is from a file has a record of all student's information including name, Id, scores and their assigned professor for each class. 1. Based on records in the table above, give an example for each: a. schema b. field c. record d. file e. tuple 2. How many tuples does the file contain? How many fields are there per record? 3. What problem would you encounter if you wanted to produce a ranking list by student first names or initials? 4. How would you solve this problem by altering the file structure