#3 Score History

[Dave MacGugan]

If a grade is entered or changed, there should be a
record of when this change was made, who made it, and
what the previous entry was.

This will make gradebook++ a little more 'secure'.

// (The User ID who entered this. It COULD just be
the TeacherID, but later, more than one person may
have access to this grade. A Teacher's assistant, for
example)

EnteredByUserID

// (The IP address of the user who entered this.)
EnteredByUserIP

// (Time Stamp it!)
TimeEntered

In addition, there should be a separate table
called 'ScoreHistory'. Whenever a score is updated, the
old info will be put here. Of course this will not have any
unique keys, since a record can conceivably be updated
two times at once (as far as the resolution of DateTime,
anyway)

Just a thought. Should be easy to implement.

-Dave MacGugan