Assume that a student table in a university database has an index on StudentID (the primary key). and additional indexes on Major, Age, Marital status, and HomeZipCode.
Further, assume that the universit wanted a list of students majoring in computer science, over the age of 25, and Married.
How could indexes be used so that only records that satisfy the qualification are accessed?