Describe the advantage of database approach over traditional file processing system.
Answers
=======
The principal advantages of DBMS over file processing system:
• Flexibility: Because programs and data are independent, programs do not have to be modified when types of unrelated data are added to or deleted from the database, or when physical storage changes.
• Fast response to information requests: Because data is integrated into a single database, complex requests can be handled much more rapidly than locating data separately. In many businesses, faster response means better customer service.
• Multiple access: Database software allows data to be accessed in a variety of ways (through various key fields), by using several programming languages (both3GL and nonprocedural4GL programs). • Lower user training costs: Users often find it easier to learn such systems and training costs may be reduced. Also, the total time taken to process requests may be less, which would increase user productivity.
• Less storage: Theoretically, all occurrences of data items need be stored only once, thereby eliminating the storage of redundant data. System developers and database designers often use data normalization to minimize data redundancy. Here are some disadvantages:
• DBMS subjects business to risk of critical data loss in its electronic format and can be more readily stolen without proper security. • The cost of a DBMS can be prohibitive for small enterprises as they struggle with cost justification for making investment in the infrastructure.
• Improper use of the DBMS can lead to incorrect decision making as people take presented data for granted as accurate.
• Data can be stolen by weak password security policy.
The advantages are as follows:-
1. Database facilities quick and easy management and storing of data.
2. It can store vast amount of data.
3. It eliminates duplication of data. Suppose a school has two registers one for school fees collection and the another for library books. A student needs to change his address. But his address is only changed in school fee register, not in library register. So now school has two records of the address for the same student. Database eliminates duplication of data as information in a database is centrally located.
4. Since data is stored in one central location, it also controls inconsistency if data. In the above example, if we change the address in the database, it will reflect all the records of the student.
5. Database allows us to share and collect data. It also validates the data being stored.
6. Database maintains standard data security and integrity.
I hope it helps you.
Please mark my answer as brainlist answer.