GK Question

technology medium mcq

Which normal form eliminates transitive dependencies in database design?

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

Answer: 3NF

Third Normal Form (3NF) requires that a table is in 2NF and has no transitive dependencies (non-key attributes depending on other non-key attributes). This reduces redundancy and update anomalies. BCNF is a stricter version of 3NF handling certain edge cases in dependency relationships.

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