UTpaper

Free mock tests & test series

Question 122Asked in BPSC TRE 2.0 (2023) Computer Science Class 11-12

If every non-key attribute is fully dependent on the primary key, then the relation will be in

  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 plus full functional dependency of every non-key attribute on the whole primary key, so there are no partial dependencies.

From BPSC TRE 2.0 (2023) Computer Science Class 11-12 — Previous Year Paper

This is question 122 of BPSC TRE 2.0 (2023) 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.