Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database.
Advantages:
1. Sharing:
DBMS helps create a data environment where many users can come and
use properly managed data.
2. Security:
A database admin can allow read and write access to any users with the database which improves the security and avoids data breaches.
3 Minimum data inconsistency:
Data inconsistency means the different versions of data are used in the same place. a well-managed database can model the relationship and update the old data easily.
4 Access to data:
Querying data is easy through SQL which cannot be done in a file-based system.
Disadvantages:
1. High cost:
The maintenance of the server might get overhand if the database is not normalized and the program makes an unnecessary query.
2. Staff cost:
An educated DBMS staff is required to maintain the server at all times which might get costly.
3. Performance:
compared to a file-based system, DBMS might get more computer resource hungry. a system might get too slow at times.
4. database complexity:
The complexity of a database might increase over time which might get harder to manage over time. With an increase in complexity the number of technical staff increases.