Match the following: Left Side Right Side (i) 5 NF (a) Transitive dependencies…
2005
Match the following:
Left Side | Right Side |
|---|---|
(i) 5 NF | (a) Transitive dependencies eliminated |
(ii) 2 NF | (b) Multivalued attribute removed |
(iii) 3 NF | (c) Contains no partial functional dependencies |
(iv) 4 NF | (d) Contains no join dependency |
- A.
i- (a) ii-(c) iii-(b) iv-(d)
- B.
i-(d) ii-(c) iii-(a) iv-(b)
- C.
i-(d) ii-(c) iii-(b) iv-(a)
- D.
i-(d) ii-(c) iii-(b) iv-(a)
Attempted by 243 students.
Show answer & explanation
Correct answer: B
The correct matching is based on standard database normalization definitions.
(i) 5NF eliminates join dependencies, matching with (d).
(ii) 2NF eliminates partial functional dependencies, matching with (c).
(iii) 3NF eliminates transitive dependencies, matching with (a).
(iv) 4NF eliminates multivalued dependencies, matching with (b).
Therefore, the correct sequence is (d)(c)(a)(b).
A video solution is available for this question — log in and enroll to watch it.