Advantages of Database Management System
1. Data redundancy and inconsistency: Different programmers create files and programs in different formats and different programming language. The same information may be duplicated in several files. For example, the address and contact details of an employee may appear in a file that consists of Payment-account records and in a file that consists of view - account records. This redundancy leads to higher storage and cost. This also leads to data inconsistency, that is, multiple copies of same data might not match. For example, if the address of the employee is modified, then it should be reflected in Payment-account records and not in view-account records. 2. Difficulty in accessing data: Suppose the manager needs to find out the names of all employees who are not available during particular slot of time. Now, the manager instructs the data processing department to generate list of such employees. There is no such program to meet the requests; however it can generate