Second Normal Form (2NF) takes the structure a step further by removing partial dependencies. A table is in 2NF if it's already in 1NF and all non-key columns are fully dependent on the primary key.

Learn how to use ER diagrams for database normalization and optimization in DBMS. ER diagrams can help you visualize, communicate, validate, simplify, and enhance your data.