Second Normal Form
Second Normal Form (2NF) is a database normalization principle that aims to reduce data redundancy and improve data integrity. A table is in 2NF if it is already in First Normal Form (1NF) and all non-key attributes are fully functionally dependent on the entire primary key. This means that no non-key attribute should depend on only a part of a composite primary key.
To achieve 2NF, any partial dependencies must be removed by creating separate tables. This process helps organize data more efficiently, ensuring that each piece of information is stored only once, which simplifies updates and reduces the risk of inconsistencies.