Which of the following normal forms deals with ensuring that non-key…
2024
Which of the following normal forms deals with ensuring that non-key attributes are fully functionally dependent on the primary key ?
- A.
First Normal Form (1NF)
- B.
Second Normal Form (2NF)
- C.
Third Normal Form (3NF)
- D.
Boyce-Codd Normal Form (BCNF)
Attempted by 207 students.
Show answer & explanation
Correct answer: B
The fundamental requirement of Second Normal Form (2NF) is the elimination of partial dependencies.
What it means: A partial dependency occurs when a non-key attribute depends on only a part of a composite primary key, rather than the entire key.
The Rule of 2NF: For a table to be in 2NF, it must first be in 1NF, and every non-key attribute must be fully functionally dependent on the primary key. This means if your primary key is a combination of columns (e.g.,
StudentID+CourseID), every other column in that table must require both IDs to find the value, not just one of them.