Re: Normalising a two-to-one relationship

So if I stick with two tables what do I do about the primary key in the second table (fixtures_teams)?

Thanks,

T

"David Cressey" <david_at_dcressey.com> wrote in message news:nGH36.379$2X4.32245_at_petpeeve.ziplink.net...
> The two table solution you outline is more normalized than
> the one table solution you are contemplating.
>
> Having said that, the next question is, which design is
> better? It's possible that the one table solution will serve your needs
> better, regardless of normalization. Remember, normalization is
> a design principle, not an absolute golden rule.
>
> Thomas Baker wrote in message <92nf9t$d6c$1_at_uranium.btinternet.com>...
> >I am trying to set up a database schema for a football game. Each
 fixture
> >has two teams playing in it. Should that information go in the fixtures
> >table with venue and other one-to-one information or should it have its
 own
> >table?
>
>
>
Received on Sun Dec 31 2000 - 15:48:44 CET