Define database normalization and its main goals

Database normalization is the technique of organizing data to reduce redundancy and improve data integrity. It involves dividing large tables into smaller ones and linking them via relationships. The primary goals are eliminating duplicate data and ensuring dependencies make sense. First Normal Form eliminates repeating groups; Second removes partial dependencies; Third removes transitive dependencies. While normalization improves write efficiency, denormalization is sometimes used to speed up reads in analytics.