Re: Database Design problem

From: Tim Ferguson <FergusonTG_at_softhome.net>
Date: Tue, 29 Nov 2005 18:52:37 GMT
Message-ID: <Xns971DC0842353Agarbleme4455656@62.253.170.163>

Wallace Reis <wallace.reis_at_gmail.com> wrote in news:dmfvhg$g5o$1 @domitilla.aioe.org:

> Your model allows the folowing datasets to occur:
>
> Real Madrid X Manchester
> Chelsea X Real Madrid
> Chelsea X Manchester
> Chelsea X Chelsea (!)
>
>

Apart from the last one, which can indeed be fixed with a constraint, what is wrong with the first three?

(looking forward to the time when City has bought out United and the team is now called Manchester Incorporated...)

Tim F Received on Tue Nov 29 2005 - 12:52:37 CST