Posts

Showing posts from August, 2021

Advantages of DBMS

  Data Independence The DBMS provides an abstract view of the data that hides details such as, how data is stored, how it is represented. Abstraction of such kind provides a advantage of Data Independence.   Easy Access to Data DBMS provide many useful utility commands or techniques that are used to retrieve data as per user need in a efficient way.     Data Integrity Data Integrity can be defined as overall accuracy, completeness, and consistency of data.   DBMS provide a high level of Data Integrity by enforcing integrity constraints on data. ( We will discuss later Integrity Constraints ). Centralized Management In FPS, data scattered in various files, and files may be in different formats, writing new application programs to retrieve the appropriate data from different files is difficult. DBMS provides an easy way to join different relations ( tables ), so that we can extract required data from different relations in an easy manner.   Atomicity In many ...