The primary purpose of database normalization in design is to reduce data redundancy and improve data integrity. This process involves organizing a database in such a way that dependencies are properly enforced and data is stored efficiently across tables. By minimizing duplication, normalization ensures data consistency and simplifies data maintenance. It also aids in optimizing query performance, making it easier to retrieve information accurately and quickly, which is essential for effective data management in relational databases.