How do you transform a table into second normal form?

To transform a table into Second Normal Form (2NF), you first ensure that it is in First Normal Form (1NF), meaning it has no repeating groups and all entries are atomic. Next, identify and eliminate partial dependencies by ensuring that all non-key attributes are fully functionally dependent on the entire primary key, not just a part of it. This often involves creating separate tables for the attributes that depend on only a portion of the composite primary key, thus ensuring that every non-key attribute is fully dependent on the primary key. Finally, establish foreign key relationships between the original and new tables to maintain data integrity.