Decomposition help in eliminating some of the problems of bad design

Decomposition in database design is a fundamental normalization technique used to improve overall schema quality and structure significantly. It specifically targets and eliminates data redundancy, which is a primary cause of inconsistencies and various anomalies during operations like insertion or deletion. Since decomposition effectively addresses all three specific issues listed in the options, selecting All of the above is logically sound and aligns with standard database theory principles regarding bad design remediation in relational systems.