LEARN WITH ME (DBMS)

A. FUNCTIONS OF DBMS

    The Database Management System has a lot of functions namely:

• DATA DEFINITION
• The DBMS handles how to organize and manage data, including defining the structure and format of a data.
• DATA MANIPULATION
• The DBMS handles users request and allows users to interact with the database. This includes retrieving and updating data
• DATA SECURITY AND INTEGRETY
• The DBMS enforces security measures to ensure that only the authorized users have the access to the data.
• DATA RECOVERY AND CONSISTENCY
• In case of technical problems or crashes the DBMS must be able to recover the lost data. 
• Concurrency management allows multiple users accessing and modifying  data simultaneously without any conflict.  
• DATA DICTIONARY
• Provides a list or description about your data, Which helps the users to easily define the data.

 

B. ADVANTAGES OF DBMS 

• REDUCED DATA REDUNDANCY 
• The DBMS avoids data redundancy by keeping a single copy of the data. Which eliminates the unnecessary duplication of data and saves storage.
• DATA INTEGRITY 
• By keeping a single copy of a data it ensures the data's consistency and changes to the data will be reflected to all data. 
• DATA INDEPENDENCE 
• The structure of DBMS requires the data to be independent of other data which means that the data are separated and changes in database will not be affected.
• DATA SECURITY 
• The DBMS provide security measures to ensure the authorized users can only have the access and prevents unauthorized access.
• DATA CONSISTENCY 
• DBMS ensures data is consistent across the database.
• EASIER USE OF DATA 
• The data are easier to manipulate.
• LESS STORAGE
• Since DBMS avoids data redundancy occupies less storage space.

C. DISADVANTAGES OF DBMS 

• COMPLEXITY 
• There is no doubt that DBMS is complicated to set up and manage.
• EXPENSE 
• DBMS may cost you to invest in software, hardware and etc.
• VULNERABILITY 
• DBMS may still be vulnerable to security threats.
• SIZE 
• The DBMS may consume a large amount of space as your data grows making it difficult to handle.
• TRAINING COSTS 
• Teaching an individual or more people to be the new database administrator may be time consuming.
• COMPATIBILITY 
• DBMS may not work smoothly with other software, causing compatibility issues.
• LOCKING-IN OF TECHNOLOGY
• Choosing a specific DBMS, can be challenging for you to switch. For you will be required to redesign your system from scratch.