Question

Which of the following statements accurately describes Third Normal Form (3N

  • F in database normalization?
A A table is in 3NF if it is in Second Normal Form (2NF) and all non-key attributes are directly dependent on the primary key, but not necessarily on the entire key.
B A table is in 3NF if it is in First Normal Form (1NF) and all attributes are functionally dependent on the primary key, and there are no transitive dependencies between non-key attributes.
C A table is in 3NF if it is in Second Normal Form (2NF) and has no partial dependencies of non-key attributes on any part of the primary key.
D A table is in 3NF if it is in Third Normal Form (3NF) and includes a candidate key in addition to the primary key.
E A table is in 3NF if it is in Fourth Normal Form (4NF) and all multi-valued dependencies are resolved.
Practice Next

Hey! Ask a query