Consider the following instance of the Students relation, sorted by age. Assume that these tuples are stored in a sorted file in the order shown; the first tuple is on page 1, the second tuple is also on page 1; and so on. Each page can store up to three data records; so the fourth tuple is on page 2. Explain the data entries that each of the following indexes.
Index: An unclustered index on name using Alternative (2)
sid
name
login 53831 Madayan madayan@music 53832 Guldu guldu@music 53666 Jones jones@cs 53688 Smith smith@ee 53650 Smith smith@math
age gpa 11 1.8 12 2.0 18 3.4 19 4.0 19 3.8
O Such index cannot be created.
O < Guldu, (1,2) >, < Jones, (1,3) >, < Madayen, (1,1) >, < Smith, (2,1) >, < Smith, (2,2) >.
O < Guldu, (1,1) >, < Jones, (1,2) >, < Madayen, (1,3) >, < Smith, (2,1) >, < Smith, (2,2) >.
O < Madayen, (1,1) >, < Guldu, (1,2) >, <Jones, (1,3) >, < Smith, (2,1) >, < Smith, (2,2) >.