Briefly describe the advantages of a database management system (DBMS).
CS Professional · Information Technology and Systems Audit · PYQS · December 2015
Briefly describe the advantages of a database management system (DBMS).
Answer & Explanation:
The Advantages of a DBMS are: Improved availability: One of the principle advantages of a DBMS is that the same information can be made available to different users. Minimized redundancy: The data in a DBMS is more concise because, as a general rule, the information in it appears just once. This reduces data redundancy and therefore significantly reduces the cost of storing information on hard drives and other storage devices. Accuracy: Accurate, consistent, and up-to-date data is a sign of data integrity. DBMSs foster data integrity because updates and changes to the data only have to be made in one place. Program and file consistency: Using a database management system, file formats and system programs are standardized. This makes the data files easier to maintain because the same rules and guidelines apply across all types of data. The level of consistency across files and programs also makes it easier to manage data when multiple programmers are involved. User-friendly: Data is easier to access and manipulate with a DBMS as in most cases, DBMSs also reduce the reliance of individual users on computer specialists to meet their data needs. Improved security: DBMSs allow multiple users to access the same data resources. It also allows the usage of passwords to restrict data access.
Topics: Database Management Systems
Related Questions in this Topic
- Discuss about RDBMS and Object oriented DBMS with examples.
- Distinguish between the following: Hierarchical and network DBMS
- Write short notes on the following: Distributed Database
- Describe the various types of files that can be created in SQL Server databases.
- In spite of the advantages of using a Database Management System (DBMS), there are a few situations or circumstances in ...