vendredi 30 janvier 2015

Soccer league ER diagram


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/conceeded(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 enter image description here


I may or may not include the second tire of this league otherwise I don't think I actually need the league table.


Am I anywhere near the right track? Any help would be appreciated.





Aucun commentaire:

Enregistrer un commentaire