DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Minimizes redundancy and maximizes consistency
|
|
|
Accept end-user requests via multiple, different network environments
|
|
|
Sophisticated algorithms ensure that multiple users can access the database concurrently without compromising its integrity
|
|
|
Enables recovery of the database after a failure
|
Detailed explanation-1: -Data integrity management is another important DBMS function. The DBMS promotes and enforces integrity rules, thus minimizing data redundancy and maximizing data consistency. The data relationships stored in the data dictionary are used to enforce data integrity.
Detailed explanation-2: -Data integrity is the maintenance and assurance of the accuracy and consistency of data over its entire life-cycle. In contrast, data redundancy is the repetition or superfluity of data. Thus, this is the main difference between data integrity and data redundancy.
Detailed explanation-3: -A DBMS can reduce data redundancy and inconsistency by minimizing isolated files in which the same data are repeated. The DBMS may not enable the organization to eliminate data redundancy entirely, but it can help control redundancy.
Detailed explanation-4: -Data consistency is ensured in a database because there is no data redundancy. All data appears consistently across the database and the data is same for all the users viewing the database. Moreover, any changes made to the database are immediately reflected to all the users and there is no data inconsistency.
Detailed explanation-5: -Fortunately, data replication can help prevent data redundancy by storing the same data in multiple locations. With data replication, companies can ensure consistency and receive the information they need at any time.