Disadvantages of File-Based System
Explore the common problems encountered in file based data management systems such as data redundancy, inconsistency, difficult data access, security issues, and concurrency problems. Understand why these challenges have led to the adoption of more efficient and secure database systems for better organizational data handling.
We'll cover the following...
Keeping in mind the university management system discussed in the previous lesson, we will shine a light on the problems that occur when we use a file-based system, which in turn are the reasons we shifted to database systems.
1. Data redundancy
Often, within an organization, files and applications are created by different programmers from various departments over long periods. This can lead to data redundancy, a situation that occurs when the same data is present in many places (files).
For example, if ...