Column Normal Form Description I 2 NF (c) contain no partial functional…
2013
Column | Normal Form | Description |
|---|---|---|
I | 2 NF | (c) contain no partial functional dependencies |
II | 3 NF | (a) transitive dependencies eliminated |
III | 4 NF | (b) multivalued attribute removed |
IV | 5 NF | (d) contains no join dependency |
- A.
(a) (c) (b) (d)
- B.
(d) (a) (b) (c)
- C.
(c) (d) (a) (d)
- D.
(d) (b) (a) (c)
- E.
(c)(a)(b)(d)
Attempted by 62 students.
Show answer & explanation
Correct answer: E
Second Normal Form (2NF) eliminates partial functional dependencies (c). Third Normal Form (3NF) removes transitive dependencies (a). Fourth Normal Form (4NF) handles multivalued attributes (b). Fifth Normal Form (5NF) ensures no join dependencies exist (d). This combination matches Option 4.
A video solution is available for this question — log in and enroll to watch it.