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 ...