The goal of database normalization in data design is to organize the data in a way that reduces redundancy and improves data integrity. This process involves structuring a database into multiple related tables, ensuring that each piece of data is stored only once. By eliminating duplicate data and establishing clear relationships between tables, normalization helps maintain consistency and accuracy across the database. It can also enhance query performance and ease the process of database maintenance, ultimately leading to a more efficient data management system.