[Nottingham] SQLite and 'locking'

[David Aldred]

On Monday 26 February 2007 17:21, Ovid wrote:
> Most bugs in database applications stem from lack of data integrity and
> what you're describing smacks of a violation of third normal form.  For
> this form, every field in a table must be dependent on the primary key
> and on nothing else.  Your 'booked_by' is dependent on 'booked' and
> this suggests that bad data can creep into the system.

Good point: in fact I don't think there's any real need for the 'booked' field 
if the 'booked_by' field being set implies a booking anyway!

-- 
David Aldred