Transitive dependency
A dependency is transitive when one item depends on another indirectly through an intermediate item rather than directly.
100 SQL Server Mistakes and How to Avoid Them
A transitive dependency occurs when a non-key attribute depends on another non-key attribute rather than directly on the key.
- How it is used
- Uses 3NF to identify attributes determined by nonprime attributes and separate them into related relations.
- How deep it goes
- Defines nontransitive dependence and demonstrates several relation splits, without formal dependency notation or algorithms.
- Examples
- Uses product type descriptions, salespeople, sales areas, customers, and customer contacts as dependency examples.
- What you can do after
- Apply it by decomposing relations and reconnecting them through foreign keys when nonprime attributes identify other attributes.
Read how 100 SQL Server Mistakes and How to Avoid Them explains transitive dependency →
Grokking Relational Database Design
A transitive dependency is a functional dependency in which a nonkey attribute depends on another nonkey attribute that depends on a key.
- How it is used
- Uses transitive dependencies to check database tables against 3NF and BCNF requirements.
- How deep it goes
- Defines the dependency chain, explains its anomalies, and demonstrates decomposition with foreign keys; it stops short of later normal forms.
- Examples
- Uses employee-department data and a purchase-payment_method-user relationship to expose direct and indirect dependencies.
- What you can do after
- Diagnose transitive dependencies and redesign affected tables with separate entities and foreign-key links.
Read how Grokking Relational Database Design explains transitive dependency →
Microservices Patterns, Second Edition
A dependency introduced indirectly through another dependency rather than declared directly by the application.
- How it is used
- Explains how indirect dependencies complicate technology-stack compatibility and propagate build-time coupling.
- How deep it goes
- Traces an indirect Gradle dependency into downstream tests and discusses version compatibility, without prescribing resolution steps.
- Examples
- Uses Java and Maven version conflicts, a Terraform provider blocking a Kubernetes upgrade, and Gradle project dependencies.
- What you can do after
- Diagnose build impact by tracing an indirect Gradle project dependency to downstream recompilation and tests.
Read how Microservices Patterns, Second Edition explains transitive dependency →
Also covered in
- Build High Value Software SystemsIn early access (MEAP)
- Secrets of the JavaScript Ninja, Third EditionIn early access (MEAP)
- Grokking Web Application Security
- Java Persistence with Spring Data and Hibernate epub
Related concepts
- dependencykind of · A dependency is a component, resource, or prerequisite that another software component or activity relies on to function, build, or proceed.
- Go compilercontrasts with · The Go compiler is the program that checks Go source code and translates it into executable machine code or an intermediate representation.
- normalizationaddresses · Normalization is the process of transforming or organizing data or representations according to rules to achieve a consistent form, scale, or structure.
- third normal formcontrasts with · Third normal form is a relational schema condition in which the relation is in second normal form and non-key attributes depend only on the key, not transitively on other non-key attributes.
- build-time couplingconfigures · Build-time coupling is a dependency in which a change to one software element requires other elements to be recompiled and retested.
Questions about transitive dependency
What is transitive dependency?
A dependency is transitive when one item depends on another indirectly through an intermediate item rather than directly.
Which Manning books explain transitive dependency?
100 SQL Server Mistakes and How to Avoid Them, Grokking Relational Database Design and Microservices Patterns, Second Edition.
What is the difference between transitive dependency and Go compiler?
A dependency is transitive when one item depends on another indirectly through an intermediate item rather than directly. The Go compiler is the program that checks Go source code and translates it into executable machine code or an intermediate representation.
What is transitive dependency a kind of?
Transitive dependency is a kind of dependency. A dependency is a component, resource, or prerequisite that another software component or activity relies on to function, build, or proceed.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.


