Original: This phenomenon is known as an insertion anomaly .
Simplified: This process is known as Database normalisation .