Database Normalisation Questions
The second normal form (2NF) in database normalization is a level of database normalization that ensures that all non-key attributes in a table are fully dependent on the primary key. In other words, it eliminates partial dependencies by requiring that each non-key attribute is dependent on the entire primary key, rather than just a part of it. To achieve 2NF, a table must first be in 1NF and then ensure that there are no partial dependencies present.