Match each normal form in Column I with the corresponding description in…
2013
Match each normal form in Column I with the corresponding description in Column II, then select the sequence of description codes for I–IV.
Column I | Normal form | Column II | Description |
|---|---|---|---|
I | 2NF | (a) | Transitive dependencies of non-prime attributes on a key are eliminated. |
II | 3NF | (b) | Every non-trivial multivalued dependency has a superkey determinant. |
III | 4NF | (c) | No non-prime attribute is partially dependent on a candidate key. |
IV | 5NF | (d) | Every non-trivial join dependency is implied by candidate keys. |
Answer: E. (c)(a)(b)(d) — ConceptNormalization distinguishes dependency rules by level. Second and Third Normal Forms constrain functional dependencies; Fourth Normal Form constrains…
- 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 184 students.
Show answer & explanation
Correct answer: E
Concept
Normalization distinguishes dependency rules by level. Second and Third Normal Forms constrain functional dependencies; Fourth Normal Form constrains multivalued dependencies; Fifth Normal Form constrains join dependencies.
For matching questions, identify the dependency type named by each normal form and then record its description code in the requested order.
Application
Column | Normal form | Governing rule | Code |
|---|---|---|---|
I | 2NF | No non-prime attribute depends on only part of a candidate key. | (c) |
II | 3NF | A non-prime attribute does not depend transitively on a key. | (a) |
III | 4NF | Every non-trivial multivalued dependency has a superkey determinant. | (b) |
IV | 5NF | Every non-trivial join dependency is implied by candidate keys. | (d) |
Cross-check
The progression from 2NF to 3NF stays within functional-dependency refinement.
The next two levels move from multivalued dependencies in 4NF to join dependencies in 5NF.
Therefore the required sequence for I–IV is (c)(a)(b)(d).
A video solution is available for this question — log in and enroll to watch it.
Explore the full course: Mppsc Assistant Professor Computer Science Paper 2