Where the First Normal Form deals with atomicity of data, the Second Normal Form (or 2NF) deals with relationships between composite key columns and non-key columns.

• 在第二范式中，任何非关键字字段必须依赖整个主关键字。