I am designing a database to capture the history of a sports league. The league currently has 3 divisions but this has changed from season to season. The number of teams in each division has also varied from season to season. Obviously, there are numerous fixtures to capture. How should I design the relationships ?
One season has many divisions but one division appears in many seasons. One division has many teams and teams have different divisions each season. A fixture is a match between two teams. Is it better to set up a 'one division to many fixtures' table or a 'one team to many fixtures'
Thanks for any help