Question

Difference between traditional file processing system and database management system.

Answer 1

1. A database management system coordinates both the physical and the logical access to the data, whereas a file-processing system coordinates only the physical access.2.A database management system is designed to allow flexible access to data (i.e. queries), whereas a file-processing system is designed to allow predetermined access to data (i.e. compiled programs).3. A database management system is designed to coordinate multiple users accessing the same data at the same time. A file-processing system is usually designed to allow one or more programs to access different data files at the same time. In a file-processing system, a file can be accessed by two programs concurrently only if both programs have read-only access to the file.4.Redundancy is control in DBMS, but not in file system.5. Unauthorized access is restricted in DBMS but not in the file system.6. DBMS provide back up and recovery whereas data lost in file system can't be recovered.7. DBMS provide multiple user interfaces. Data is isolated in file system.

Answer 2

Hey !$<b>$

File-processing system :

- It has problem of data redundancy.
-Data is insecure.
-Cannot store data permanently.
-Cannot change and access file-oriented data.
-Cannot recall or recover the file-oriented data.

Database management system :

-It can reduce data redundancy to a large extent.
-Provide more security to data.
-Can store data permanently.
-Can change and access data in DBMS.
-DBMS solve such type of problem.