Second Normal Form (2NF)

Each attribute must be functionally dependent on the primary key.

•  If the primary key is a single attribute, then the relation is in 2NF
• The test for 2NF involves testing for FDs whose left-hand-side 
• attribute are part of the primary key
• Disallow partial dependency, where non-keys attributes depend on
•  part of a composite primary key
• In short, remove partial dependencies

2NF improves data integrity.

• Prevents update, insert, and delete anomalies.