Re: Normalising a two-to-one relationship

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:47:47 CET