Here is the well known general description http://en.wikipedia.org/wiki/Database_normalization. It would be good if newly generated Derby 10.6 docs would contain howtos WITH involved Java classes mentioned. John