Which normal form allows multi-valued dependencies to be removed?

  • First Normal Form (1NF)
  • Fourth Normal Form (4NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
Fourth Normal Form (4NF) is the normal form that allows multi-valued dependencies to be removed. 4NF is an extension of third normal form (3NF) and deals specifically with situations where there are multiple independent multi-valued dependencies between attributes. By decomposing the table into smaller tables and ensuring each table has a single theme, 4NF helps in removing such complex dependencies and reducing data redundancy.
Add your answer
Loading...

Leave a comment

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