Illuminating the Closure of Functional Dependencies in Databases

What Is Meant by the Closure of a Set of Functional Dependencies?

A functional dependency is a one-way dependency between two attributes at any given time. For a unique attribute

of value A there is one value of the attribute B associated with it through the relation. Even if the values for the attribute change, there is only one, as described by Harrington(2009). A functional dependency, as explained by Elmasri & Navathe (2015), is a constraint between two sets of attributes from the database.

Elmasri & Navathe (2015) defined F as a set of functional dependencies that are specified on relation schema R. They go on to describe a closure F+ of F as a set of all functional dependencies that could be inferred from F.

References

Elmasri, R., Navathe, S. B. (2015). Fundamentals of Database Systems, 7th Edition [VitalSource Bookshelf version]. Retrieved from https://bookshelf.vitalsource.com/books/9781323139899

Harrington, J. L. (2009). Relational Database Design and Implementation. : Elsevier Science. Retrieved from http://www.ebrary.com

Posts in this series