Which normal form is based on the concept of 'full functional dependency'?
2011
Which normal form is based on the concept of 'full functional dependency'?
- A.
First Normal Form
- B.
Second Normal Form
- C.
Third Normal Form
- D.
Fourth Normal Form
Attempted by 782 students.
Show answer & explanation
Correct answer: B
The Second Normal Form (2NF) is based on the concept of full functional dependency. It requires that all non-key attributes be fully dependent on the entire primary key, eliminating partial dependencies found in First Normal Form.
A video solution is available for this question — log in and enroll to watch it.