-Which of the Following Is True Regarding the Course File

Multiple Choice

$\begin{array}{lllll}\begin{array}{lll}\text { Course } \quad\quad \text { Record }\\\text { Name } \quad \quad \text { Address }\\\begin{array}{|l|l|}\hline \text { Anatomy } & 2 \\\hline \text { Biology I } & 1 \\\hline \text { Calculus I } & 4 \\\hline \text { Shakespeare } & 3 \\\hline \text { Statistics II } & 5 \\\hline\end{array}\\\text { Index }\end{array}&\begin{array}{lllll}\text { Record }&\text { Course\quad\quad\quad Course\quad\quad\quad\quad Number of\quad Professor }\\\text { Number }&\text { Number\quad\quad\quad Name\quad\quad\quad\quad Credits\quad\quad in Charge }\\\begin{array}{lr}1\\2\\3\\4\\5\end{array}&\begin{array}{|l|l|l|l|}\hline \text { BIOL1001 } & \text { Biology I } & 4 \quad\quad\quad& \text { Smith } \\\hline \text { BIOL3020 } & \text { Anatomy } & 3 & \text { Jones } \\\hline \text { ENGL2540 } & \text { Shakespeare } & 3 & \text { Duncan } \\\hline \text { MATH2000 } & \text { Calculus I } & 4 & \text { Stevens } \\\hline \text { MATH3500 } & \text { Statistics II } & 3 & \text { Jones } \\\hline\end{array}\\\end{array}\end{array}$
-Which of the following is true regarding the Course file and its index?

A) The index shown is the only index that can be built over this file.
B) The Professor in Charge field cannot be indexed because it is not unique.
C) Because the Course Name field is indexed, the Course file should be sorted so that it is in order by Course Name.
D) The Number of Credits field cannot be indexed because it has only two values.
E) The Course Name field in the index must be in sorted order.