943,917 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Marked Solved
  • Views: 580
  • MS SQL RSS
Dec 20th, 2008
0

Need advice for creating Table

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
fishky is offline Offline
7 posts
since Mar 2008
Dec 21st, 2008
0

Re: Need advice for creating Table

Separate tables, it will make your life easier for the tracking purposes, also if you really want you can extend this beyond two tables...
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 873
Code tags enforcer
peter_budo is offline Offline
6,656 posts
since Dec 2004
Dec 21st, 2008
0

Re: Need advice for creating Table

Thanks mate. Really needed advice from a more experienced guy. Was thinking the same.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
fishky is offline Offline
7 posts
since Mar 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: Fulltext Index problems
Next Thread in MS SQL Forum Timeline: Need to connect my hosted server to sql





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC