Hi everyone
i am planning to start a aussie rules(sport) database and want to include player stats. My problem is how to include the player statistics. I was thinking of setting one table as the player details like first name, last name, middle name, playerid and another as playerid, season, quarterid, teamid, gameid, and the stats. I was going to use an integer figure for the playerid but was thinking when i go to input data, would be too hard to keep track off. Should i use one or two tables or is there a better way. What do you guys think
Thanks
i am planning to start a aussie rules(sport) database and want to include player stats. My problem is how to include the player statistics. I was thinking of setting one table as the player details like first name, last name, middle name, playerid and another as playerid, season, quarterid, teamid, gameid, and the stats. I was going to use an integer figure for the playerid but was thinking when i go to input data, would be too hard to keep track off. Should i use one or two tables or is there a better way. What do you guys think
Thanks