Well, the purpose of the database is to store information on a football,soccer league, stating the facts and figures about the teams. For example dta would be updated accordingly for if a team would play a game and score 2 goals, the played column would increase 1 and the goals would increase by 2. Sorry for my bad description, heres a table .
Team, played, Won, Draws, Lost, goals-scored, goals-against, Points
England, 8, 7, 1, 0, 19, 6, 22
Brazil, 9, 6, 2, 1, 11, 2, 20
hope my question is abit clearer.