DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Structural dependence
|
|
|
Structural independence
|
|
|
Data dependence
|
|
|
Data independence
|
Detailed explanation-1: -Structural independence exists when changes in the database structure do not affect DBMS ability to access data. Structural dependence exists when changes in the database structure do not affect DBMS ability to access data.
Detailed explanation-2: -Structural dependence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data. Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
Detailed explanation-3: -A file system exhibits structural dependence, which means that access to a file is dependent on its structure. For example, adding a customer date-of-birth field to the CUSTOMER, Given this change, none of the previous programs will work with the new CUSTOMER file structure.
Detailed explanation-4: -Conversely, data independence exists when it is possible to make changes in the data storage characteristics without affecting the application program’s ability to access the data.