I have created a database that can keep track of different football leagues. We can have more than one league and for each league we can assign teams and the fixtures. Also we keep the score of each team. Later on I will create come SQL statements to find the wins, draws, loses etc for each team in a league.
I attached an image of my DB layout.
Any feedback about improvements that can take place will be appreciated.
I'm reading this in U.S.A..... I don't know where you're from but over here football is very different than Euro- we call that scoccor.
A team doesn't have a score. A score or goals is dependent on a game. A team may have a total goals for the life or existence since it started, but you can derrive that by adding up the goals it scored in every game it ever played.
For example the absolute VERY FIRST TIME Team 'x' was created or first started..... it hadn't scored any goals.