I am planning on creating a database to track teams and players in a soccer league. The stats I wish to track are as follows...
goals scored/conceded(gk), assists, minutes played, cards received and leading scorers.
As well as overall standings and fixtures and results. I have created an ER diagram and I think I have all the required tables but have some m:n relationships which I know shouldn't exist so am hoping my relationships are correct
Update updated er diagram
I may or may not include the second tire of this league otherwise I don't think I actually need the league table.
will it cause me any problems if i implement it as is. i am not sure if it is ok to have 2 cols in the
fixtures table that are referencing one column from the
teams table. And my
goals_scored table has the same two fk's as my
Am I anywhere near the right track? Any help would be appreciated.