well in theory yes, but it really depends on the relationships/data and growth... its one of those 'i can't give a decent answer unless i know the whole picture' things. and whereas the theory may say one thing, performnce/maintainance/useabilty may decree another :)
-----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 15:51 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] one-to-one relationship 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] ##################################################################################### Note: Any views or opinions are solely those of the author and do not necessarily represent those of Channel Four Television Corporation unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] Thank You. ##################################################################################### -- ** 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]
