Database Normalisation Questions
Database normalization is the process of organizing data in a relational database to eliminate redundancy and improve data integrity. It involves breaking down a database into multiple tables and establishing relationships between them through keys. The main goal of normalization is to minimize data duplication and ensure that each piece of information is stored in only one place. This helps to reduce data anomalies, such as update, insertion, and deletion anomalies, and improves the efficiency and accuracy of data retrieval and manipulation operations. Normalization is typically achieved through a series of normal forms, such as first normal form (1NF), second normal form (2NF), and so on, each building upon the previous one to further refine the database structure.