AI engineering glossary · SQL databases

What is functional dependency?

Functional dependency: A relationship where the value of one set of columns determines the value of another, written A -> B. Normal forms are defined in terms of these dependencies. Normalisation theory is built on these.

Level: advancedTopic: SQL databases

Functional dependency: an example

pincode -> city means each pincode always maps to one city.

Related terms

More SQL databases terms

Where you learn it

Functional dependency is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.

Before you go

Take the cheat sheet with you

One free PDF: the key AI-engineering terms, formulas and Python idioms. No spam; unsubscribe any time.