View source for Normalization
* Makes data atomic. * Reduces redundancy. Benefits of Normalization * Decreased storage consumption. * Removed redundancy means less data. * Better / Faster (/Stronger) searches. * Less data to scan. * Easier searches on (previously) mixed data. * Improved data integrity. * When data is only in one place you only have to get it right/fix it once. Vertical partitioning Horizontal partitioning