Database Normalisation Questions
The role of keys in database normalization is to establish relationships between tables and ensure data integrity. Keys are used to uniquely identify records within a table and are crucial for maintaining data consistency and avoiding data duplication. Primary keys are used to identify individual records, while foreign keys are used to establish relationships between tables by referencing the primary key of another table. By using keys, database normalization helps eliminate data redundancy and improves the efficiency and accuracy of data retrieval and manipulation operations.