Second Normal Form
Explore how Second Normal Form builds on First Normal Form by removing partial dependencies from database tables. Understand how breaking tables into linked relations reduces redundancy, improves data integrity, and optimizes storage, preparing you for advanced normalization concepts.
We'll cover the following...
We'll cover the following...
Second normal form (2NF)
To be in second normal form, a relation must be in first normal form (1NF) and it must not contain any partial dependencies. So a relation is in 2NF as long as it has no partial dependencies, i.e., no non-prime attributes (attributes which are not part of any candidate key) is dependent on any proper subset of a composite primary key of the table.
Example
STUDENT Relation
| Stud_Id | Course_Id | Course_Fee |
|---|---|---|
| 1 | C1 | 1000 |