I have my table structure set out like this, this is my attempt to normalise the database.
Season, divison, home, away and referee where repeating groups
The purpose of the databse will be so that I can query any of the results for any given team (will always look at home teams seperate from...