Which normal form deals with removing partial dependency on a composite primary key?
A
Third Normal Form (3NF)
B
Second Normal Form (2NF)
C
First Normal Form (1NF)
D
Boyce-Codd Normal Form (BCNF)
Correct Answer: Option B — Second Normal Form (2NF)
Explanation:
Second Normal Form (2NF) removes partial dependency, ensuring that non-key attributes are fully dependent on the entire composite primary key rather than just a part of it. This step follows 1NF and further reduces redundancy in the database.