Data Model

sparkymark75

sparkymark75

sparkymark75

Soldato
Joined
8 Jan 2003
Posts
3,782
Location
Scotland
Can someone give me some inspiration on how to model a league in a database?

This will obviously comprise of teams, players, fixtures, results, scoring, etc. But then there's things to complicate matters such as players leaving a team during a season and playing for another team.
 
Not far off what I came up with. (Excuse the use of MS Access)

league.png
 
When I try and relate the Scorer, Assist1 and Assist2 fields in tblFixtureGoals to the PlayerID in tblPlayers, it generates another 2 aliases for the tblPlayers table. There's still only one actual tblPlayers table, must be the way Access handles relationships.

Haven't used Access for years, used to SQL Server.
 
You must log in or register to reply here.
Back
Top Bottom