Database Design problem

From: paulhutchings7204 <paul_hutchings_at_blueyonder.co.uk>
Date: 24 Nov 2005 08:08:20 -0800
Message-ID: <1132848500.303575.282710@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. Received on Thu Nov 24 2005 - 10:08:20 CST