Re: Database Design problem

"paulhutchings7204" <paul_hutchings_at_blueyonder.co.uk> wrote in message news:1132848500.303575.282710_at_z14g2000cwz.googlegroups.com...
> Could some kind person please help with a little Database Design
> problem I've come up against?
>
> I am in the process of designing a football online management system
> with which I intend to display results fixtures etc. My dilemma is I
> have a TEAM table and the relationship to the fixture table is that of
> many to 2 (2 teams in a fixture a fixture have many teams.....) this is
> the dilemma can anyone think of a way of combating this to ensure data
> integrity etc is met.
>
> All help would be most appreciated.
>
> Yours (banging my head against the wall)
> Paul.
>

http://www.intelligententerprise.com/010101/celko.jhtml

-- 
David Portas
SQL Server MVP
--