Re: Normalising a two-to-one relationship
From: David Cressey <david_at_dcressey.com>
Date: Mon, 01 Jan 2001 00:07:56 GMT
Message-ID: <wTP36.383$2X4.33007_at_petpeeve.ziplink.net>
Date: Mon, 01 Jan 2001 00:07:56 GMT
Message-ID: <wTP36.383$2X4.33007_at_petpeeve.ziplink.net>
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_at_uranium.btinternet.com>...
>So if I stick with two tables what do I do about the primary key in the
>second table (fixtures_teams)?
Received on Mon Jan 01 2001 - 01:07:56 CET