·
Data Redundancy
·
Data Inconsistency
·
Difficulty in Accessing Data
·
Data Isolation
·
Integrity Problems
·
Atomicity Problem
·
Concurrent Access anomalies
·
Security Problems
Data
Redundancy
Data Redundancy is same information’s are duplicated in several files. This makes data redundancy.
Data Inconsistency
Data Inconsistency means different copies of the same data are not matching. This occurs as the result of update operations that are not updating the same data stored at different places.
Data Redundancy is same information’s are duplicated in several files. This makes data redundancy.
Data Inconsistency
Data Inconsistency means different copies of the same data are not matching. This occurs as the result of update operations that are not updating the same data stored at different places.
Example:
Address Information of a customer is recorded differently in different
files.
Difficulty in Accessing Data
It is not easy to retrieve information using a conventional file processing system. Convenient and efficient information retrieval is almost impossible using conventional file processing system.
Data Isolation
Data are scattered in various files, and the files may be in different format, writing new application program to retrieve data is difficult.
It is not easy to retrieve information using a conventional file processing system. Convenient and efficient information retrieval is almost impossible using conventional file processing system.
Data Isolation
Data are scattered in various files, and the files may be in different format, writing new application program to retrieve data is difficult.
Integrity Problems
The data values may need to satisfy some integrity constraints.
The data values may need to satisfy some integrity constraints.
For example the balance field Value must
be greater than 5000. We have to handle this through program code in file
processing systems. But in database we can declare the integrity constraints
along with definition itself.
