International Journal of Computer Applications
In this paper, the author applies the data mining techniques in the area of data cleaning as effective in discovering Constant Conditional Functional Dependencies (CCFDs) from relational databases. These CCFDs are used as business rules for context dependent data validations. Conditional Functional Dependencies (CFDs) are an extension of Functional Dependencies (FDs) which captures the consistency of data by supporting patterns of semantically related constants. Based on the hierarchy between FDs, CFDs and Association Rules: union of association rules are CFDs, while union of CFDs are FDs.