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.

DATA INDEPENDENCE - it requires that data be independent in the database and the software used to access the database.

DATA SECURITY - it can have additional security measures as part of the database software product.

DATA CONSISTENCY - data consistency is maintained in the database environment.

EASIER USE OF DATA - data is easier to use in the database environment.

LESS STORAGE - data redundancy is reduce if not eliminated, so the database will occupy less storage space.

WHAT ARE THE CONS OF DBMS?

COMPLEXITY - DBMS are extremely complex.

EXPENSE - this requires careful planning because of the possibility of the need for additional hardware.

VULNERABILITY - it is vulnerable to partial or  complete destruction when a breakdown of hardware components occur or in software mistake.

SIZE  - A typical mainframe database is very large.

TRAINING COST - it must first train one or more individuals to be the database administrator for the new product.

COMPATIBILITY - it is sometimes incompatibile with other database systems.