What do you think to the idea of having separate tables to allow of easier expansion if it's needed?
Ade -----Original Message----- From: Gordon Thomas [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 15:41 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] one-to-one relationship if you are down to 1-1 relationships, then the data is 'incorrectly' organised and you need to rethink the table structure, as probably this can be shrunk down to a single table. Fundementals of Database Systems by Elmasri/Navarthe explains the whole thing very well and has been my stalwart design/normalisation book for more years than i care to think about. G. Gordon Thomas Database Administrator Channel Four Television [EMAIL PROTECTED] Tel +44 (0) 20 7306 8278 http://www.channel4.com -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
