Advanced Database Management System - Tutorials and Notes: Various uses of attribute closure

Thursday, 28 August 2014

Various uses of attribute closure


What are the uses of attribute closure A+ / Purposes of finding attribute closure / Attribute closure in DBMS


Several uses of attribute closure:

1. Used to check whether an attribute (or set of attributes) forms a key or not.
2. Used to find easily all the functional dependencies hold in a relation.
For example, to check whether a FD like A B holds in a relation, find the A+. If B is in A+, then the functional dependency A B is valid.
3. Used as an alternate way to find Closure of FDs (F+).
For every attribute or set of attributes on the left hand side of the arrow in a functional dependency, find the Closure. This process results in F+.





Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents