Match List - I with List - II : Choose the correct answer from the options…
2023
Match List - I with List - II :
Choose the correct answer from the options given below:
- A.
(A)-(III),(B)-(II),(C)-(I),(D)-(IV)
- B.
(A)-(IV),(B)-(I),(C)-(II),(D)-(III)
- C.
(A)-(II),(B)-(III),(C)-(IV),(D)-(I)
- D.
(A)-(IV),(B)-(I),(C)-(III),(D)-(II)
Attempted by 82 students.
Show answer & explanation
Correct answer: B
Correct matching: a concise mapping of each normal form to the property it enforces.
BCNF → every functional dependency is implied by the candidate keys.
5NF → every join dependency is implied by the candidate keys.
1NF → all underlying domains contain scalar (atomic) values only.
4NF → every multi-valued dependency is implied by the candidate keys.
Brief justification:
BCNF enforces that any nontrivial functional dependency must have a key on the left side, so it corresponds to functional dependencies.
5NF ensures lossless decomposition with respect to join dependencies, so it corresponds to join dependencies.
1NF requires atomic (scalar) domains so that each attribute value is indivisible.
4NF prevents undesirable multi-valued dependencies unless they are implied by keys, so it corresponds to MVDs.
Therefore the correct associations are: BCNF ↔ functional dependencies, 5NF ↔ join dependencies, 1NF ↔ scalar domains, and 4NF ↔ multi-valued dependencies.