Grade Table

The Grade table stores the information relating to grades. This table has foreign key relationships with the PersonActivity and GradeScale tables. The following illustration shows the column properties of the Grade table.

• The GradeId column is the primary key for a grade and it is an identity column.
• The GradeScaleId column is the foreign key that links the Grade table to the GradeScale table.
• The Name column is a required attribute that contains the word or words that are associated with a GradeId.
• The Value column is an optional attribute that contains the numeric value of the lowest score associated with a GradeId. Not all grades have a numeric value. This column has a float data type.
• The AffectAverage column is a Boolean field and has a bit data type. This column indicates whether the grade is included when calculating an average for a person or for a group. The default is 1 (TRUE).