Unit 4 · Database Management Systems Paper 2 CS · September 2022

Match List I with List II.
Choose the correct answer from the options given below:
List I List II
A. BCNF I. It removes multivalued dependency.
B. 3NF II. It is not always dependency preserving.
C. 2NF III. It removes transitive dependency.
D. 4NF IV. It removes partial functional dependency.

List I	List II
A. BCNF	I. It removes multivalued dependency.
B. 3NF	II. It is not always dependency preserving.
C. 2NF	III. It removes transitive dependency.
D. 4NF	IV. It removes partial functional dependency.

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

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

← Previous question Next question →

Match List I with List II.Choose the correct answer from the options given below:List IList IIA. BCNFI. It removes multivalued dependency.B. 3NFII. It is not always dependency preserving.C. 2NFIII. It removes transitive dependency.D. 4NFIV. It removes partial functional dependency.

Explanation

More Database Management Systems questions

Match List I with List II.
Choose the correct answer from the options given below:
List I List II
A. BCNF I. It removes multivalued dependency.
B. 3NF II. It is not always dependency preserving.
C. 2NF III. It removes transitive dependency.
D. 4NF IV. It removes partial functional dependency.