Re: Database Design problem

Tim Ferguson wrote:
>
> create table fixtures (
> matchnumber sometype,
> hometeam sometype references teams,
> awayteam sometype references teams,
> isonneutralground bit,
> dateoffixture datetime,
> result shorttext,
> etc etc
> )

Your model allows the folowing datasets to occur:

Real Madrid X Manchester
Chelsea X Real Madrid
Chelsea X Manchester
Chelsea X Chelsea (!)

--
wallace reis