The information that is in the two tables should possibly only be in one table.
Stephen
[EMAIL PROTECTED] wrote:
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.
-- ** 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]
