Original: This phenomenon is known as a deletion anomaly .
Simplified: This process is known as Database normalisation .