Normalization of Tables: From 2NF to 3NF

The second normal form (2NF) ensures that each non-key attribute of a table is fully dependent on the primary key. However, it is still possible for a table to have transitive dependencies, where non-key attributes depend on other non-key attributes....