Which of the following statements about Third Normal Form (3NF) is true?

PYQ IBPS SO CRP SPL-XII (2022)

Which of the following statements about Third Normal Form (3NF) is true?

  1. A.

    A table is in 3NF if it is in 2NF and every non-prime attribute is non-transitively dependent on every key of the table.

  2. B.

    A table is in 3NF if it is in 2NF and every non-prime attribute is dependent on every non-key attribute of the table.

  3. C.

    A table is in 3NF if it has no transitive dependencies and every non-prime attribute is partially dependent on a candidate key.

  4. D.

    A table is in 3NF if it has no repeating groups and all attributes are atomic.

  5. E.

    A table is in 3NF if it is in 1NF and has only one candidate key.

Attempted by 74 students.

Sign up free to check your answer

Sign up free

Explore the full course: Ibps So It Prelims

Loading lesson…