Database Normalisation Questions
The role of functional dependencies in database normalization is to identify and eliminate redundancy and anomalies in a database. Functional dependencies help in determining the relationships between attributes in a relation and ensure that each attribute is functionally dependent on the primary key. By analyzing functional dependencies, normalization techniques can be applied to break down a relation into smaller, well-structured relations, reducing data redundancy and improving data integrity.