Q.What are the main advantages of using DBMS?
Ans.
Some important advantages of database management system are as follows:
Data Independence.
Database approach provides the facility of data independence. It means that the data and the application programs are separate from each other. The user can change data storage structures and operations without changing the application programs. The user can also modify programs without reorganization of data.
Redundancy Control.
Redundancy means duplication of data in multiple files. The data in database appears only once. It is not duplicated. If the data is required at many places, the same data is used at all places.
Consistency Constraints.
Consistency constraints are the rules that must be followed to enter data in the database. If a data does not fulfill these constraints , it cannot be entered in the database. Database management system provides an easy way of applying different consistency constraints that ensure the consistency of the data in the database.
Support Complex Data Relationships.
Database management system allows the user to design complex data structures. It enables the user to logically view and access data in different ways.
Data Security Features.
Data security is the protection of the database from unauthorized access. The database management system provides several procedures to maintain data security. The security is maintained by allowing access to the database through the user of passwords. Every user of database system should not be able to access all the data.
Database Backup & Recovery.
Database Management System provides the facility of backup and recovery. Backup facility is used to store an additional copy of data. The data can be recovered from this file if the original file is lost or damaged. A utility in DBMS is used to recover data. The utility rebuilds the data by using backup copy of the data.
Advanced Capabilities.
DBMS provides advanced access capabilities for online reporting. It uses internet for advanced capabilities.
Ans.
Some important advantages of database management system are as follows:
Data Independence.
Database approach provides the facility of data independence. It means that the data and the application programs are separate from each other. The user can change data storage structures and operations without changing the application programs. The user can also modify programs without reorganization of data.
Redundancy Control.
Redundancy means duplication of data in multiple files. The data in database appears only once. It is not duplicated. If the data is required at many places, the same data is used at all places.
Consistency Constraints.
Consistency constraints are the rules that must be followed to enter data in the database. If a data does not fulfill these constraints , it cannot be entered in the database. Database management system provides an easy way of applying different consistency constraints that ensure the consistency of the data in the database.
Support Complex Data Relationships.
Database management system allows the user to design complex data structures. It enables the user to logically view and access data in different ways.
Data Security Features.
Data security is the protection of the database from unauthorized access. The database management system provides several procedures to maintain data security. The security is maintained by allowing access to the database through the user of passwords. Every user of database system should not be able to access all the data.
Database Backup & Recovery.
Database Management System provides the facility of backup and recovery. Backup facility is used to store an additional copy of data. The data can be recovered from this file if the original file is lost or damaged. A utility in DBMS is used to recover data. The utility rebuilds the data by using backup copy of the data.
Advanced Capabilities.
DBMS provides advanced access capabilities for online reporting. It uses internet for advanced capabilities.