Consistency Constraints in File processing System vs Consistency Constraints in Database

Consistency Constraints in File processing System vs Consistency Constraints in Database

Consistency Constraints in File processing System vs Consistency Constraints in Database

In Database it is possible that some fields are repeated in different files(or tables). This situation can beĀ  represented in database.For example a non-key field in one table can be a key field in another table. In database it is very easy to identfy and represent such relationship if exist.Once such a relation is established any change in a field at any one place will reflect at other places simulateneously, no need to manually update at all places.

Where as in file processing system it is not possible to establish such relationship,hence we have to manually ensure consistency through application program.