ACtE08 · Chapter 8Mock Test 02🏛️ Past Licensure QuestionID: a617b986
Which relational database normal form eliminates transitive functional dependencies to minimize data redundancy?
Which relational database normal form eliminates transitive functional dependencies to minimize data redundancy?
Multiple Choice Options
- A
1NF
- B
2NF
- C✓ Correct Option
3NF
- D
BCNF
Detailed Technical Solution & Explanation
A relation is in Third Normal Form (3NF) if it is in 2NF and no non-prime attribute is transitively dependent on any candidate key (i.e., for every non-trivial functional dependency , is a superkey or is a prime attribute).
Option Analysis:
•
Option A (1NF): Eliminates repeating groups and enforces atomic attribute values.
•
Option B (2NF): Eliminates partial dependencies on candidate keys.
•
Option C (3NF): Correct. Eliminates transitive dependencies on candidate keys.
•
Option D (BCNF): Stricter normal form requiring to be a superkey for every functional dependency.
Reference: Mock Test 02NEC Licensure Syllabus