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.

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.