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
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.
Sent from: http://sqlite.1065341.n5.nabble.com/
sqlite-users mailing list