Difference between DBMS and File Management System

File Management System
1. In the database system, there exists a collection of Interrelated files and a set of application programs to access and modify these files. 1. In a file management system, it stores permanent records in various files. Application programs are needed to extract records from and add records to the appropriate files.
2. A database may be generated automatically or it may be computerized. These database may be created and maintained by a DBMS. 2. It supported by conventional operating systems such as MS-DOS.
3. A database system so designed doesn't involve the problem of data redundancy or inconsistency. 3. Since the files and application programs are created by different programmers over a long period of time. Data in files is likely to get repeated. Redundancy can lead to inconsistency that is the various copies of the same data may contain different information.
4. DBMS provides the security mechanisms to prevent unwanted users from accessing certain parts or whole of database. 4. Not every user of the system should be able to access all the data. In a file management system, the application programs are added in an ad-hoc manner, it is difficult to enforce such security constraints.
5. Almost all the database systems allow multiple users to update database at the same time. 5. Multiple user access to the information is difficult to provide through the conventional file processing system. This is due to the use of the application programs which have not been coordinated previously.