4NF - Problem caused by independent multivalued dependencies is eliminated - Database

Q.  The problem caused by independent multivalued dependencies is eliminated in which of the normal form?
- Published on 19 Oct 15

a. 3NF
b. BCNF
c. 4NF
d. 5NF

ANSWER: 4NF
 

    Discussion

  • Nirja Shah   -Posted on 29 Oct 15
    - There are no non-trivial multivalued dependencies other than a candidate key in the Fourth normal form (4NF)

    - It builds on the first three normal forms (1NF, 2NF and 3NF) and the Boyce-Codd Normal Form (BCNF).

    - It states that, in addition to a database meeting the requirements of BCNF, it must not contain more than one multivalued dependency.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)