Relational Database Design and Modeling for Software Engineers
Ask Author
Back to course home

0% completed

Second Normal Form (2NF)
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

The Second Normal Form (2NF) is the next stage in database normalization after achieving the First Normal Form (1NF). 2NF builds on 1NF by eliminating partial dependencies, ensuring that every non-key attribute in a table is fully dependent on the entire primary key. In other words, 2NF requires that each non-key attribute must rely on the whole primary key, not just part of it.

Note: A table needs to be in 1NF before it can be converted to 2NF. Partial dependencies only apply to tables with composite primary keys (primary keys consisting of multiple columns).

.....

.....

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible