Question

onsider the following two relations for Millennium College: STUDENT(StudentID, StudentName, CampusAddress, GPA) REGISTRATION(StudentID, CourseID, Grade) Following is a typical query against these relations: SELECT Student_T.StudentID, StudentName, CourseID, Grade FROM Student_T, Registration_T WHERE Student_T.StudentID = Registration_T.StudentID AND GPA > 3.0 ORDER BY StudentName; On what attributes should indexes be defined to speed up this query? Give the reasons for each attribute selected.

Answer 1

Answer:

Student Id, Gpa

Explanation:

a)

Student Id,GpA are the attributes selected to speed up this query. The reason behind these selections are because the student Id and Gpa are the primary key and foregin key respectively.

b)

Student Id- This is the Primary key

GPA-This is the Foreign key