Database Normalisation Questions
The role of normalization in reducing data redundancy is to eliminate or minimize the duplication of data within a database. By organizing data into separate tables and establishing relationships between them, normalization ensures that each piece of information is stored in only one place. This helps to avoid inconsistencies, update anomalies, and unnecessary storage of redundant data, leading to a more efficient and reliable database system.