Q: Database Design daily data I have a question about database design, I'm wondering how do you go about saving daily user data. 
For example I have a table called Accounts
structure is accountID, accountName, DailyScore, WinRate
how can I keep track of DailyScore and WinRate for each day. Do I keep creating tables named after a date or is there a better way.

A: Accounts has info about each "account" -- account_id, name, etc.  This table is rather static -- you occasionally add a row, and sometimes change something.
Scores has new rows every day -- account_id, date, score, etc.  The PRIMARY KEY would have two columns: account_id and date.
Not knowing how winRate is calculated, it is unclear where, if anywhere, it should be stored.  Is it calculated from the scores??
