Joris Dobbelsteen wrote:
>>
>> CREATE TABLE attendance
>> (
>> attendanceid serial primary key,
>
> Why you have this??? You already have (entered,timeperiod,studentid)
> that you can use, since that must be unique too. Try to avoid surrogate
> keys as much as possible (it really increases performance and
> ease-of-writing for complex queries!
Correct me if I am wrong, but wouldn't a simple number be a lot easier
to look up than a composite key?