Posts

Showing posts from September, 2023

LEARN WITH ME (DBMS)

Image
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 dat