Posts

Showing posts from February, 2023

DBMS(Database Management System)

  Database Management System  A. Functions of DBMS >Data Definition -The DBMS must be able to accept data definitions (Externals, 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 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, ok r minimize the effects of a system crash. >Dara Dictionary -The DBMS must provide a system database called the database dictionary.  B. Advantage of DBMS >Reduced Data Redundancy -In database system, system redundancy us avoided by keeping a single copy of the data. >D...