What are the limitations of file system that can be overcome by a relational DBMS?
The limitations of file system that can be overcome by a relational DBMS are:
Difficulty in Access: Files do not provide any mechanism to retrieve data. Data in a file system is accessed through application programs. Developers may not anticipate all possible ways data may be accessed, making it difficult to access data in the required format.
Difficulty in Handling Large Data: File system becomes difficult to handle when the number of files increases and volume of data grows.
Controlled Data Sharing: It is very difficult to enforce access control in a file system. Different categories of users should have limited access (like read-only), but this is hard to implement through application programs.
Data Redundancy: In file systems, same data is maintained in multiple files, leading to redundancy. DBMS avoids this by linking tables through common fields.
Explanation
The textbook context explicitly mentions these limitations in section 8.2.1 and 8.3.1. The context discusses difficulty in access (A), difficulty handling growing files and data, controlled data sharing (F), and redundancy issues demonstrated through the STUDENT and ATTENDANCE file example where SName need not be maintained in both files. A relational DBMS overcomes these by providing organized, logically related data structures.