What are the advantages of a DBMS? - Information Technology

Answer in Brief

What are the advantages of a DBMS?



Redundancy is controlled: In File Processing System, duplicate data is created in many places because all the programs have their own files. This creates data redundancy which in turns wastes labor and space. 'In Database Management System, all the files are integrated in a single database. The whole data is stored only once at a single place so there is no chance of duplicate data.

Sharing of Data: In a database, the users of the database can share the data among themselves. There are various levels of authorization to access the data. And consequently the data can only be shared based on the correct authorization protocols being followed.

Data Security: Data Security is vital concept in a database. Only authorized users should be allowed to access the database and their identity should be authenticated using a username and password. Unauthorized users should not be allowed to access the database under any circumstances as it violates the integrity constraints.

Enforces integrity constraints: Constraints are used to store accurate data because there are many users who feed data in database. Data stored in database should always be correct and accurate. DBMS provides the capability to enforce these constraints on database.

Provides backup and recovery of data: Data loss is a very big problem for all the organizations. In traditional tile processing system, a user needs to backup the database after a regular interval of time that wastes lots of time and resources._If the volume of data is large then this process may take a very long time.

Concept: Advantages of DBMS
  Is there an error in this question or solution?
Chapter 2: Introduction to DBMS - Exercise [Page 29]


Balbharati Information Technology (IT) 11th Standard HSC Maharashtra State Board
Chapter 2 Introduction to DBMS
Exercise | Q 6.2 | Page 29

      Forgot password?
Use app×