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