After today's class, i finally understood that 3NF does not mean that we have a situation where C depends on B, and B depends on A. Prior to today's class, i thought the normalization process could theoretically go on forever, to XNF. Correct me if i am wrong, now i see that the 4NF is the most/best we could do to a database. It is good to see the example where 2NF is the same as the 3NF. Therefore, in order to achieve 4NF and reduce redundancy, we could only have one attribute depending on the primary key in each database. Personally i think the extended auto example in the CP is very helpful to illustrate this point. However, at times i still find it hard to understand the normalization process by reading its definition, without the use of example.
Comments