League Admin

[Paul Smith]

I am trying to design a database to administer a local league, I have
maintain stats for each team for each game.

I have the following tables:

Weeks
Divisions
Fixtures

My problem is with the home and away teams on each fixture. Should this go
on the Fixture table, or do I need a another table which has the Fixture ID
and the home and away teams?

I am sure designing league DBs must be a common question but my goggle
searches have not turned up anything, so can anyone offer any assistance?

 

[Duane Hookom]

What is a Fixture? In my area, a fixture could be a light fixture, bathroom
fixture,...
If a fixture is the equivalent of a game or contest, and you only have two
teams involved in a fixture, you could place both teams in a single record.

Database purists would suggest a single record for each team involved in the
contest. This would allow more flexibility with entering other statistics.