Database Normalisation Questions
The role of normalization in improving database performance is to eliminate data redundancy and ensure data integrity. By organizing data into separate tables and reducing duplication, normalization reduces the storage space required and improves data retrieval efficiency. It also minimizes the chances of data inconsistencies and anomalies, leading to more accurate and reliable data. Overall, normalization helps optimize database performance by streamlining data storage and retrieval processes.