Normalisation is used to make sure a database structure is suitable for general-purpose querying and free of certain undesirable characteristics. Which includes the insertion, update, and deletion of anomalies that could lead to a loss of consistency and accuracy of the data stored in a database.
So when this is ignored, obviously it will be one crazy database.
Do some research, perhaps on the 1st-6th normal form.