What Are 10 Disadvantages Of File Based Approach?

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

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.