UTpaper

Free mock tests & test series

Question 120Asked in BPSC TRE 3.0 (2024) Computer Science Class 11-12

Which normal form ensures that every non-prime attribute in a table is fully functionally dependent on the primary key?

  1. AFirst Normal Form (1NF)
  2. BSecond Normal Form (2NF)
  3. CThird Normal Form (3NF)
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (B) Second Normal Form (2NF)

Explanation

2NF requires 1NF and that every non-prime attribute depend fully on the whole primary key, with no partial dependency on part of a composite key.

From BPSC TRE 3.0 (2024) Computer Science Class 11-12 — Previous Year Paper

This is question 120 of BPSC TRE 3.0 (2024) Computer Science Class 11-12 — Previous Year Paper. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.