DBMS and how useful it was
WHAT ARE THE FUNCTIONS OF DBMS? DATA DEFINITION - it accepts data definitions(external, internal and conceptual schemas, and all associated mappings) in source form and convert to the appropriate object form. DATA MANIPULATION - it handle request from the user to retrieve and update existing data or to add a new data to the database. DATA SECURITY AND INTEGRITY - it monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator. DATA RECOVERY AND CONCURRENCY - it has the capability to recover from, or minimize the effects of a system crash. DATA DICTIONARY - it provide a system database called the database dictionary. WHAT ARE THE PROS OF DBMS? REDUCED DATA REDUNDANCY - data redundancy is avoided by keeping a single copy of the data. DATA INTEGRITY - since a single copy of a particular data is stored in the database, you can be certain that the changes to the data will be reflected in all future uses of that data. ...