A full functional dependency is a state of database normalization that is equivalent to the normalization standard of Second Normal Form (2NF). In short, it means that it meets the requirements of First Normal Form (1NF) and that all non-key attributes are fully functionally dependent on the primary key.
Learn Database Normalization – 1NF, 2NF, 3NF, 4NF, 5NF
This is not as complicated as it sounds. Let's dig a little deeper into this.
Before a database can be fully functionally dependent, it must first conform to First Normal Form. All this means is that each attribute must contain a single atomic value.
For example, the following table does not meet 1NF because employee Tina is associated with two locations, both in one cell:
