Question

Advantages of transaction processing in dbms

Answer 1

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.

In DBMS, Data can be shared in between authorized user of database. All the users have their own right to access the database up to a level. Database Administration has complete access of database. He can assign users to access the database. Others users are also authorized to access database and also they can share data between them. Many users have same authority to access the database.

Answer 2

$\green{ \fcolorbox{grey}{grey}{ \checkmark \: \textsf{Verified \: answer}}}$

Advantages of transaction processing in DBMS

• ⟹ Data Redundancy
• ⟹ Data Security
• ⟹ Data Concurrency
• ⟹ Data Integration
• ⟹ Data Access
• ⟹ Decision making
• ⟹ Data Backup and Recovery
• ⟹ Data Migration

━━━━━━━━━━━━━━━━━━━━━━