In which normal form are all non-prime attributes fully functionally dependent on the primary key?

  • Boyce-Codd Normal Form (BCNF)
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
All non-prime attributes being fully functionally dependent on the primary key characterizes a table in Boyce-Codd Normal Form (BCNF). BCNF is a higher level of normalization that ensures the removal of certain types of anomalies and dependencies in the database.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *