The goal of normalization in the logical database design process is to eliminate data redundancy.
Redundant data can lead to data inconsistencies and anomalies when performing insertions, updates, and deletions.
By applying normalization techniques, redundant data is eliminated, and data is structured in a way that ensures each piece of information is stored only once, maintaining data integrity and consistency.