Anonymous

What Are 10 Disadvantages Of File Based Approach?

3

3 Answers

Anonymous Profile
Anonymous answered
1) Security Problems- explicit programming required
2) Integrity Problems- rules needed to be programmed explicitly
3) Concurrent access anomalies- multiple access of same file in case of multiple user system
4) Data Isolation- related data required by different programs of same application may resides in diff isolated files
5) Unanticipated queries- handling sudden queries can be difficult
6) Data redundancy
7) Data inconsistency
8) Duplication of data
9) No standardized control over organization of files
10) No standardized control over structure of files
John cena Profile
John cena answered
In file based approach you need to maintain distinct files of every department where as in DBMS the whole data is located at a single place. It means anyone can access the data anywhere if have the required privileges.
Robert Maroney Profile
Robert Maroney answered
The  file based suffers from redundant data and inconsistent data also it has poor data integrity. It has no Primary key and multipart fields. The Relational Database has none of these problems

Answer Question

Anonymous