DBMS FUNCTIONS, ADVANTAGES AND DISADVANTAGES
DBMS FUNCTIONS DATA DEFINITION The DBMS must be able to accept data definitions(external, internal and conceptual schemas, and all associated mappings) in source form and convert to the appropriate object form. DATA MANIPULATION The DBMS must be able to handle request from the user to retrieve and possibly update existing data in the database, or to add a new data to the database. DATA SECURITY AND INTEGRITY The DBMS must be able to monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator. DATA RECOVERY AND CONCURRENCY The DBMS must have the capability of recover from, or minimize the effects of a system crash. DATA DICTIONARY The DBMS must provide a system database called the database dictionary. ADVANTAGES OF DBMS REDUCED DATA REDUNDANCY In database system, data redundancy is avoided by keeping a single copy of the data. DATA INTEGRITY ...