From: "David Cressey" <david@dcressey.com>
Newsgroups: comp.databases.theory
References: <92nf9t$d6c$1@uranium.btinternet.com> <nGH36.379$2X4.32245@petpeeve.ziplink.net> <92nh64$gdk$1@uranium.btinternet.com>
Subject: Re: Normalising a two-to-one relationship
Lines: 9
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Message-ID: <wTP36.383$2X4.33007@petpeeve.ziplink.net>
Date: Mon, 01 Jan 2001 00:07:56 GMT
NNTP-Posting-Host: 209.206.80.146
X-Trace: petpeeve.ziplink.net 978307676 209.206.80.146 (Sun, 31 Dec 2000 19:07:56 EST)
NNTP-Posting-Date: Sun, 31 Dec 2000 19:07:56 EST


If I were doing it,  I would make the primary key of the fixture_teams
table be a compound key, consisting of the two foreign keys.

Thomas Baker wrote in message <92nh64$gdk$1@uranium.btinternet.com>...
>So if I stick with two tables what do I do about the primary key in the
>second table (fixtures_teams)?