Database normalization aims to reduce data redundancy and improve data integrity by organizing tables. The first normal form (1NF) requires atomic values, the second normal form (2NF) targets partial dependency elimination, and the third normal form (3NF) removes transitive dependencies while ensuring every non-key attribute is fully functionally dependent on the primary key.