Thank you Keith for your useful advice. I am considering to organize the columns based on BCNF.
I guess that table t3 is needed to remove functional dependency, which means I should use table t2 and t3 instead of one table t2 with 4 columns a-d. Is that right? I am not familiar with the concept BCNF, and I want to make sure that if it is recommended to create my tables in the way you wrote. Thanks -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users