Match List I with List II. List I: A. BCNF, B. 3NF, C. 2NF, D. 4NF. List II: I. Removes multivalued dependency, II. Not always dependency preserving, III. Removes transitive dependency, IV. Removes partial functional dependency.

1. A(A)-(III), (B)-(II), (C)-(IV), (D)-(I)
2. B(A)-(II), (B)-(IV), (C)-(I), (D)-(III)
3. C(A)-(II), (B)-(III), (C)-(IV), (D)-(I)
4. D(A)-(II), (B)-(I), (C)-(IV), (D)-(III)

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: C. (A)-(II), (B)-(III), (C)-(IV), (D)-(I)

Explanation

BCNF decomposition is not always dependency preserving; 3NF removes transitive dependencies; 2NF removes partial dependencies; 4NF removes multivalued dependencies.