Richard, Yes, as compared to sql books it concentrates on the influences of good design and build of the database not how data is manipulated and later pulled etc by sql. A lot of emphasis given to interviewing techniques to establish integrity of tables. Duncan's example would require taking one of his 2 tables and interviewing say the team poeple to establish for example if it is in fact a one 2 one type, if it is, primary key in one table inserted in the other as foreign key, otherwise, if it is not, say one team in fact has 2 grounds, one to many etc. Overall good design of the database in the sense of its normalisation or optimisation facilitates sql...you can get Hernandez at http://www.cbweb.net/hardware.cfm clicking the amazon link :-)
cheers Colm Colm Brazel MA CB Publications www.cbweb.net <http://www.cbweb.net> Macromedia-Dublin UserGroup Manager http://www.mmug-dublin.com [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web Site Design & Development, Cold Fusion, general publishing including E-Books. The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication,or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify CB Publications by telephone at 353-1-4941625 or e-mail [EMAIL PROTECTED] and delete the e-mail from your system. -----Original Message----- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 16:05 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] one-to-one relationship Thanks Colm - that has good reviews on Amazon - I might get that _______________________________________________________ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 _______________________________________________________ -----Original Message----- From: Colm Brazel [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 16:00 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] one-to-one relationship 'Database Design for Mere Mortals', Hernandez, good for pondering these issues -----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 15:53 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] one-to-one relationship No.... he's right -- you need a table per entity but with an intermediary table binding teams to pitches Teams TeamID Team etc | TeamPitches TeamID PitchID | Pitches PitchID etc That gives you the flexibility to handle teams that share pitches. Obviously, put a uniqueness constraint on TeamID-PitchID in the intermediary table. -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- ** 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] ======================================================= This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. ======================================================= -- ** 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- ** 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]
