A popular rule of thumb is that a design is in 3NF if every nonkey field depends on the key, the whole key, and nothing but the key.

Question

Quizplus · Accepted Answer

This is a correct statement of Boyce-Codd Normal Form (BCNF), which is a stronger condition than 3NF. In 3NF, a nonkey field can depend on another nonkey field, but not transitively through a chain of nonkey fields. However, the statement is not a complete definition of 3NF.

A Popular Rule of Thumb Is That a Design Is