what are the advantages of database system as compared with file processing system?

Answer 1

You can have a look at this site. It provides both differences and advantages of DBMS over file processing

Answer 2

In a database, the information is already indexed in at least one way, or maybe several ways, depending on how you set it up...like, say, a mailing address database might be indexed by lastname, by firstname, by phone number, by email, and on, and on. So the program might query the database for phone number 555-1212 and search the index for that phone number quickly, and find all the other information associated with that phone number...

...whereas, with a non-indexed, file, the program would have to read each *entire* record, substring the part containing the phone number of each record, and compare it against 555-1212, and if not successful, read another record, and on and on...much more memory intensive...

In other words, with a database, some of the processing is done, beforehand...

Answer 3

Databases are organized and ready for quick information results. File processing has to take the time to determine what can be indexed, then actually do it. Information might not be indexed in the process resulting in a less reliable system.