1.

What are the advantages of a DBMS?

Answer»

Advantages of a DBMS:

1. 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 turn wastes labor and space. ‘In Database Management System, all the files are integrated into a single database. The whole data is stored only once in a single place so there is no chance of duplicate data.

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

3. Data Security: Data Security is a 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.

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

5. Provides backup and recovery of data: Data loss is a very big problem for all organizations. In a traditional tile processing system, a user needs to back up 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.



Discussion

No Comment Found