Discussion
In the context of Normalization, what is the primary requirement for a relation to be in Third Normal Form (3NF) ?
Answer: B
3NF requires that the relation is in 2NF and has no transitive dependencies.
A relation is in third normal form when it is in second normal form and no non-key attribute depends on the key only through another non-key attribute. For example, in Employee(EmpId, DeptId, DeptName), DeptName depends on EmpId through DeptId, which violates 3NF.
Having no partial dependencies is the condition for 2NF, and full functional dependency on the whole key restates it. 'All determinants must be candidate keys' is the stricter Boyce-Codd normal form.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development