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.
fishky
0
Newbie Poster
Recommended Answers
Jump to PostSeparate tables, it will make your life easier for the tracking purposes, also if you really want you can extend this beyond two tables...
All 2 Replies
Reply to this topic
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.