• 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