Update attendence table to use foreign key

[brhecker]

Update the attendance table so that is uses a foreign key into the registered students table rather than directly storing student id