>> If you think that the later is important, a ground >>is more likely to have two teams than a team is likely to have two grounds,
No way, I'd go for a football team having a ground so give the ground a foreign key from the Gaelic football team....anyone see my homesite question herabouts:-) 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: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 15:28 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] one-to-one relationship I think it's a case of what belongs to what. Does a football team have a ground or does a ground have a football team? If you think they are both valid, go with the one that makes life easiest or that can be expanded on. If you think that the later is important, a ground is more likely to have two teams than a team is likely to have two grounds, but then of course you could add to that the training grounds... Ade -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 15:23 To: [EMAIL PROTECTED] Subject: [ cf-dev ] one-to-one relationship This is a very simple question, but something I've never really given much thought before. If you've got two tables with a one-to-one relationship, how do you deal with the foreign keys? e.g. lets say you had FootballTeams and FootballGrounds (and lets pretend there aren't any teams that share grounds). In which table would you store the foreign key linking it to the other table? Or would you duplicate data and store in both. e.g: Team, GroundID Rangers, 2 Celtic, 3 Hearts, 5 Hibs, 1 Aberdeen, 4 Ground, TeamID Easter Road, 4 Ibrox, 1 Parkhead, 2 Pittodrie, 5 Tynecastle, 3 I'm sure there's a logical rule for dealing with this, but I can't think what it is. Not a very difficult issue, just something I'm pondering. 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! ---------------------------------------------------------------------- ---------------------------------------------------------------------- -- ** 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] --- 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]
