[Nottingham] SQLite and 'locking'

David Aldred david at familyaldred.org.uk
Mon Feb 26 18:03:58 GMT 2007

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

More information about the Nottingham mailing list