Re: Database Design problem
From: Wallace Reis <wallace.reis_at_gmail.com>
Date: Mon, 28 Nov 2005 19:15:08 -0300
Message-ID: <dmfvhg$g5o$1_at_domitilla.aioe.org>
Date: Mon, 28 Nov 2005 19:15:08 -0300
Message-ID: <dmfvhg$g5o$1_at_domitilla.aioe.org>
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 reisReceived on Mon Nov 28 2005 - 23:15:08 CET