On Mar 2, 2012, at 1:28 AM, Rich Rattanni wrote: > I realize design A may not be "best", but I would prefer an friendly > answer and not a canned response like I get from co-workers.
[warning: canned answer ahead] FWIW, there is some good wisdom in going down the "text book" way, aka normalization :) http://en.wikipedia.org/wiki/Database_normalization On the other hand, if your main goal is reporting, then perhaps a different form of modelization might be more effective: http://en.wikipedia.org/wiki/Dimensional_modeling Either way, applying a bit of method (the "text book" part) has its benefits. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users