Database Normalisation Questions
Transitive dependency in database normalization refers to a situation where a non-key attribute is functionally dependent on another non-key attribute, which is itself functionally dependent on the primary key. In other words, it occurs when a non-key attribute is indirectly dependent on the primary key through another non-key attribute. Transitive dependencies can lead to data redundancy and anomalies, and they should be eliminated through normalization techniques to ensure data integrity and efficiency in the database.