Consider the following two relations for Millennium College: Following is a typ...

Consider the following two relations for Millennium College:

Following is a typical query against these relations:

a. On what attributes should indexes be defined to speed up this query? Give the reasons for each attribute selected.

b. Write SQL commands to create indexes for each attribute you identified in part a.

Problems and Exercises 2–5 have been written assuming that the DBMS you are using is Oracle. If that is not the case, feel free to modify the question for the DBMS environment that you are familiar with. You can also compare and contrast answers for different DBMSs.