2012/2/24 Rita <rmorgan...@gmail.com>: > I was wondering if there is a better way to normalize this data. And also, > I will be doing queries like, what is the most recent price for the > user,mson, and what is the average price for mson in the last 3 days, etc...
Your table is already normalized. The primary key is t+user, attribute price is dependent on the entire primary key. No dependency between attributes or between parts of the primary key. However, a problem might occur if the user at the same time wants to make 2 records. -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
