Discussion
Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
Answer: B
Correct answer: False
Multivalued dependency anomalies are not harmless. Two independent multivalued facts in one relation force every combination of them to be stored, so adding one value of the first requires a new row for every existing value of the second, and the redundancy grows as their product. Splitting the relation removes the problem entirely.
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