Correct Answer - Option 2 : Decomposition
The process of breaking up or dividing a single relation into two or more sub relations is called the decomposition of a relation. Therefore anomalies are avoided by splitting the offending relation into multiple relations, is also known as Decomposition
Important Point:
Decomposition is used to eliminate some of the problems of bad design like anomalies, inconsistencies, and redundancy
