Schema for a Soccer club
You'll want to add another table Season, and another table SeasonPlayer with an FK to player, an FK to team and an FK to Season. 

Then drop the FK from Team to Player in your current schema