Declared Functional Dependency Checker
Check whether equal determinant CSV fields always have equal dependent fields in the supplied records.
Loading tool…
How to use Declared Functional Dependency Checker
Review declared rules such as code determining label. The report preserves conflicting dependent values and witness record numbers instead of deleting duplicates or pretending a finite sample proves a universal database rule.
- Enter input, dependency json.
- Choose the settings for declared functional dependency checker, then run the tool.
- Review the result and any limitations before copying or downloading it.
Good to know
- 200,000 CSV characters,5000 records and50 dependencies,with at most20 fields on each side.
- 100 detailed conflicting groups per rule,20 variants and20 record numbers per variant; full counts remain visible. A400,000-character witness preflight can refuse a larger rule combination. No automatic normalization or repair.
- Processing is local. Output is limited to 1,000,000 text characters unless a stricter file limit is stated.
Common questions
Does repeating an identical row violate a dependency?
No. A conflict needs equal determinant fields and different dependent fields. Sample success is still limited to your supplied records.
Is this input sent to a server?
No. The application processes this input inside your browser tab and does not save it to persistent storage.
Keep going with related tools
All data →CSV Foreign Key Checker
Check child records against unique parent composite keys with explicit blank-key handling.
DataSupported CSV Data Schema Validator
Check a small declared CSV schema for column types, required cells and composite primary-key uniqueness.
DataCSV Deduplicator
Remove repeated CSV records by full row or one selected column, retaining the first match.
DataCSV Conditional Record Rule Auditor
Check explicit per-record IF/THEN field rules with exact string or decimal comparisons and bounded witnesses.