this is good, the sort of discussion i was wanting. the teams/pitches thing was just an example of course. in reality the site this is for is small and won't matter much how i choose to do it, but i just wanted to get some opinions and best practice ideas.
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Gordon Thomas" To: <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: el4.co.uk> Subject: RE: [ cf-dev ] one-to-one relationship 31/10/2003 15:53 Please respond to dev 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] -- ** 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]
