Discussion
In database normalization, what problem does 4NF (Fourth Normal Form) address ?
Answer: C
4NF addresses multi-valued dependencies.
A relation is in fourth normal form when it is in BCNF and has no non-trivial multi-valued dependencies. If an employee's skills and languages are independent of each other but stored in one table, every skill must be paired with every language, which causes redundancy. 4NF splits them into Employee-Skill and Employee-Language tables.
Partial dependencies are removed by 2NF and transitive dependencies by 3NF. Join dependencies are the subject of 5NF.
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