The normal form that ensures every non-prime attribute is fully functionally dependent on every candidate key is the Second Normal Form (2NF). For a table to be in 2NF, it must first be in First Normal Form (1NF), and then all of its non-key attributes must depend on the entire primary key, not just a part of it. This eliminates partial dependencies, reducing data redundancy and inconsistency.
In database normalization, which normal form ensures that every non-prime attribute is fully functionally dependent on every candidate key?
Review the verified answer and explanation for this SPSC – Sindh Public Service Commission past-paper question on CampusFin.