Question

With a suitable example, explain the role of functional dependency in the process of normalisation

Answer 1

The normalization process uses functional dependencies to seek out and eliminate redundancy in a database schema, thereby reducing the possibility of update anomalies.

If a database schema is properly normalized, the following should hold true for all tables: all columns should be functionally dependent on the table’s primary key.

Functional dependencies allow you to verify that this is true and if it is not, determine the steps to take to normalize your tables so that it will be true (without losing any data or losing any connections between data that is related).

HOPE IT HELPS.....PLEASE MARK AS BRAINLEST