Transitive dependencies occur in a database when a non-prime attribute is functionally dependent on another non-prime attribute, which in turn is dependent on a primary key, leading to indirect dependency on the primary key. This type of dependency can cause redundancy and anomalies, and is eliminated during the process of normalization to achieve Third Normal Form (3NF).