International Journal of Innovative Research in Science, Engineering and Technology (IJIRSET)
In this paper, the authors detail about various methods prevailing in literature on strategies developed for mining functional dependencies. Efficient discovery of functional and approximate dependencies of partition is discussed in detail. An efficient algorithm for discovery functional and approximate dependencies called TANE is examined. Mining functional dependencies from data and depth first algorithms and influencing for AFD mining are examined in detail. Polynomial time queries over inconsistent databases with functional dependency and foreign keys are reviewed.