Database Normalisation

Splitting data across tables to avoid duplication. This enhance consistency. However you need to do joins to get complete data. It gets expensive when your database get large

Benefit:

1. Save database space
2. Single source of truth, prevent inconsistent data