Acar_Activity Task Module 1_Lecture_DBMS
---Activity Task Module 1--- ---Functions, Advantages and Disadvantages of DBMS--- A. Functions of DBMS *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. B. Advantages of DBMS *Reduced Data Redundancy - ...