Task of DBA are: Minimal Data Redundancy (Duplication) Due to centralized database, it is possible to avoid unnecessary duplication of information. This leads to reduce data redundancy. It prevents memory wastage. It also reduces extra processing time to get required data. Shared Data All authorized user and application program can share database easily. Data Consistency Data inconsistency occurs due to data redundancy. With reduced data redundancy such type of data inconsistency can be eliminated. This results in improved data consistency. Data Access DBMS utilizes a variety of techniques to retrieve data. Required data can be retrieved by providing appropriate query to the DBMS. Thus, data can be accessed in convenient and efficient manner. Data Integrity Data in database must be correct and consistent. So, data stored in database must satisfy certain types of constraints (rules). DBMS provides different ways to implement such type of constraints (rules). This improves data integrity in a database. Data Security Database should be accessible to user in a limited way. DBMS provides way to control the access to data for different user according to their requirement. It prevents unauthorized access to data. Thus, security can be improved. Concurrent Access Multiple users are allowed to access data simultaneously. Concurrent access to centralized data can be allowed under some supervision. This results in better performance of system and faster response. Guaranteed Atomicity Any operation on database must be atomic. This means, operation must be executed either 100% or 0%. This type of atomicity is guaranteed in DBMS.
