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?
