Flat file databases cause insertion, deletion and update anomalies. Use of relational databases where primary and foreign keys are used to link tables helps overcome these issues.
Part of Computing ScienceDatabase design and development