Hello guys. I'm trying to make a database about football games (results, managers, players etc.). For my Players table i want to include these stats:
- first and last names, nationality, date of birth (constants through time)
- games played the current season, goals scored, cards received, minutes played in games and some more (updated regularly)
I set a column ID with unique number as a primary key. My question is should i put all these columns in one table or i can split them in 2 tables - one for the constant data which wont change with time and 2nd with the stats which will change through time and updating regularly and use ID relation between them? Thanks in advance.

9 Years
Discussion Span
Last Post by fishky

Separate tables, it will make your life easier for the tracking purposes, also if you really want you can extend this beyond two tables...


Thanks mate. Really needed advice from a more experienced guy. Was thinking the same.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.