Resolve data redundancy and inconsistency in flat files by linking records via primary and foreign keys in a relational database.