Table structure in mySQL

Table structure in mySQL

I'm in the early stages of creating a database using MySQL and PHP and
would like some advice please. I have started to collate the data and
would like to start typing it into .csv files ready to import into my
tables. Before I do, I'm unsure how to layout my structured columns and
tables properly.
Ok, I'll try my best to make clear what I'm trying to create. I'd have my
home page structure similar to this website:
http://www.westhamstats.info/westham.php?west=0 where you have a choice of
selecting a list of players by season or by an A-Z list of all-time
players. Once you click on a specific player from the list of players it
would show something like this for their player profile:
http://stats.touch-line.com/playerdet.asp?playerid=41472&cust=2&lang=0&FromSTR=TRUE&compid=&teamid=1&H2H=
How many tables would I need to create?
A player table with
playerID,playerName,playerDOB,playerBirthplace,playerPosition etc.
A team table with teamID,teamName,teamNickname,teamGround,teamFounded etc.
A season table with seasonID,playerID,teamID,playerApps,playerGoals?
Or is there a quicker, more efficient way without the need to use so many
tables to link the data? Any advice would be much appreciated. Thanks in
advance. ;)