Question discussion

Which of the following statement(s) is/are correct regarding a relation in second normal form?I. It is in first normal formII. Every non-ke…

359831Medium DSSSB TGT Computer Science 0 replies 0 views
0

Which of the following statement(s) is/are correct regarding a relation in second normal form?
I. It is in first normal form
II. Every non-key attribute is fully and functionally independent on the primary key

  • AOnly I
  • BOnly II
  • CNeither I nor II
  • DBoth I and II
Correct answer: A

Explanation

A relation in 2NF must first be in 1NF, so statement I is true. In 2NF every non-key attribute must be fully functionally dependent on the primary key, not independent, so statement II is false.

Discussion 0

Nobody has replied yet. Start the discussion!