Adding the GradeScale Table

Building the Eval Data Model contains three statements that describe how grades are used:

An ACTIVITY uses a set of GRADES.

An ACTIVITY TYPE uses a set of GRADES.

A GROUP uses a set of GRADES.

The preceding references to a set of grades indicate that collections of grades exist and that an activity, activity type, and group can select a grade only from a defined set of grades. The addition of the GradeScale table allows grades to be grouped through the foreign key relationship between the GradeScale table and the Grade table. All grades in a grade scale share the same grade scale identifier.