FUNCTIONS, ADVANTAGES, DISADVANTAGES OF DBMS

 

DATA DEFINITION

In a DBMS, data is what's being dealt with and data definition is the ability to clearly define what is stored in the tables of a database. As an example, SQL is utilized in order to instruct how to store the data.   

DATA MANIPULATION  

This means that the existing data within a DBMS can be easily manipulated. Modification is easy as users can insert, delete and update their database.

DATA SECURITY AND INTEGRITY

Enhanced protection is ensured in a DBMS. It prevents any type of unauthorized access and data alteration. On the other hand, integrity is the validation and it helps maintain the overall accuracy of the system's structure.

DATA RECOVERY AND CONCURRENCY  

System failures can be unavoidable and DBMS has the ability to retrieve the lost data. Other than that, concurrency means that it can be accessed at the same time as multiple users can view it. 

DATA DICTIONARY 

A data dictionary primarily consists information regarding the data. For instance, the field names used, their relationships, source of data, its size etc.

 

 

REDUCED DATA REDUNDANCY  

The data in can be duplicated or produce multiple copies. DBMS ensures that the data does not become redundant through integrating the file.

DATA INTEGRITY 

It has constraints that must not be violated and rules that must be strictly followed as the DBMS must be consistent and reliable. Once there are changes in the data, it will be updated and shown in the future uses of it. 

DATA INDEPENDENCE 

The data in DBMS can stand alone. Each entity in a table must be declared with a primary key as they are independent with a particular key.  

DATA SECURITY 

 Through the use of the connections, the records can be secured as there are unique identifiers for them. It also has data backup.

DATA CONSISTENCY 

Data consistency is maintained with the use of unique identifier. For instance, one ID can only pertain to a single record.

EASIER USE OF DATA 

Accessing data is easy in DBMS. For example, if there is a specific record that a user needs to lookup, the result can be found using the search button. 

 

LESS STORAGE

A DBMS consumes lesser storage especially when the data is already saved in the database.

COMPLEXITY 

 The complexity of the DBMS can be encountered when inputting data and declaring data formats. Errors will pop up if they are incorrect.  

 EXPENSE 

The cost is one of its disadvantages as DBMS is not free and it can be expensive to acquire the software.

VULNERABILITY

It is vulnerable in a sense that it may destruct since it is located at a central location. Not only that but it is vulnerable due to its enhanced security.  

SIZE  

The mainframe of a database is large. If the system exceeds the maximum size of records, the system may crash.

TRAINING COSTS

 The training costs of it is expensive in order to have certifications.

COMPATIBILITY 

Compatibility issues can happen and sometimes the system used can be incompatible to be integrated with other database systems.

         LOCKING-IN OF TECHNOLOGY

If a user does not possess the proper training and software, locking in of technology may occur. They may have to start from scratch if they lack knowledge in manipulating the data.