DBMS Chap 1
Explain advantages (benefits) of DBMS over file management system. OR Explain purpose of database system. 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 and 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 ty...