Benefits of the Database Approach
Explore the advantages of using the database approach including controlling data redundancy through normalization, enabling data sharing, enforcing integrity constraints, restricting unauthorized access, and providing backup and recovery. This lesson helps you understand essential DBMS capabilities that improve data consistency, security, and reliability.
Benefits of using the database approach
We will now discuss some advantages of using a database system and the capabilities that a good DBMS should possess:
1. Control of data redundancy
In the database approach, ideally, each data item is stored in only one place in the database. This is known as data normalization, and it ensures consistency and saves storage space. In some cases, data redundancy still exists to improve system performance but it is kept to a minimum. ...