GK Question

technology medium mcq

Which normal form requires that every non-key attribute is fully functionally dependent on the primary key?

  1. 1NF
  2. 2NF
  3. 3NF
  4. BCNF

Answer: 2NF

Second Normal Form (2NF) requires: 1) Table is in 1NF, and 2) No partial dependency (non-key attributes must depend on entire primary key, not part of composite key). Eliminates redundancy from partial dependencies. Further normalization to 3NF removes transitive dependencies.

Topic Database & Programming
Exam Relevance Banking, SSC JE, Railway
More in technology Back to all questions