Consider the following two relations for Millennium College STUDENT(StudentID, S
ID: 3664642 • Letter: C
Question
Consider the following two relations for Millennium College
STUDENT(StudentID, StudentName,CampusAddress, GPA)
REGISTRATION(StudentID, CourseID, Grade)
_____________________________________________
Following is a typical query against these Relation:
__________________________________________
SELECT Student_T.StudentID,StudentName,
CourseID, Grade
FROM Sudent_T, Registration_T
WHERE Student_T.StudentID =
Registration_T.StudentID
AND GPA> 3.0
ORDER BY StudentName;
________________________________
a. On what attributes should indexes be defined to speed up this Query? PLease give reasons for each selected
Explanation / Answer
Student Id,GpA attributes selected to speed up this query because
Student Id- Primary key
GPA-Foreign key