Posts

Showing posts from February, 2023

Disadvantages of DBMS

These are some of the disadvantages of DBMS: 1. Increased Cost 2. Cost of Hardware and Software 3. Cost of Staff Training 4. Complexity 5. Need of skilled staff 6. Currency Maintenance 7. Huge size 8. Performance 9. Database failure 10. Data integrity

Advantages of DBMS

1. Better Data Transferring: Database management creates a place where users have an advantage of more and better-managed data. Thus making it possible for end-users to have a quick look and to respond fast to any changes made in their environment. 2. Better Data Security: The more accessible and usable the database, the more it is prone to security issues. As the number of users increases, the data transferring or data sharing rate also increases thus increasing the risk of data security. It is widely used in the corporate world where companies invest money, time, and effort in large amounts to ensure data is secure and is used properly. A Database Management System (DBMS) provides a better platform for data privacy and security policies thus, helping companies to improve Data Security. 3. Better data integration: Due to the Database Management System we have an access to well managed and synchronized form of data thus it makes data handling very easy and gives an integrated view of h...

Functions of DBMS

DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are Data Dictionary Management, Data Storage Management, Data Transformation and Presentation, Security Management, Multi user Access Control, Backup and Recovery Management, Data Integrity Management, Database Access Languages and Application Programming Interfaces and Database Communication interfaces.