DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Different versions of the same data appear in different places
|
|
|
Promoting accuracy, validity, and timeliness of data
|
|
|
Enables data to be shared
|
|
|
Supports multiple users at the same time
|
Detailed explanation-1: -Data redundancy occurs when the same piece of data exists in multiple places, whereas data inconsistency is when the same data exists in different formats in multiple tables. Unfortunately, data redundancy can cause data inconsistency, which can provide a company with unreliable and/or meaningless information.
Detailed explanation-2: -What is Data Inconsistency? Data inconsistency is a situation where there are multiple tables within a database that deal with the same data but may receive it from different inputs. Inconsistency is generally compounded by data redundancy.
Detailed explanation-3: -For instance, assume a hospital database. Changing the address of one patient can affect many other tables. Only one record will have correct data while the others will have false data. Hence, this is data inconsistency.
Detailed explanation-4: -Data inconsistency occurs when same data maintained. in different places do not match. If a student wants to. get changed the spelling of her name, it needs to be. Table 7.2 ATTENDANCE file maintained by class teacher.
Detailed explanation-5: -Data inconsistency problems can occur as a result of referential integrity constraint violations. Referential integrity describes the condition where all references to data in pages are valid. Db2 provides referential integrity by enforcing referential constraints on the data.