FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WHAT IS DATABASE MANAGEMENT

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Access to a file is dependent on its own structure.
A
Structural dependence
B
Structural independence
C
Data dependence
D
Data independence
Explanation: 

Detailed explanation-1: -access to a file is dependent on its own 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. Therefore, all of the file system programs must be modified to conform to the new file structure.

Detailed explanation-2: -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-3: -The linguistic principle that grammatical processes function primarily on structures in sentences, not on single words or sequences of words is termed structure-dependency. Many linguists view structure-dependency as a principle of universal grammar.

Detailed explanation-4: -For example, if Product Team A requires that the Legal Team create or approve work items related to its product, then a structural dependency exists between Product Team A and the Legal Team.

Detailed explanation-5: -The close relationship between data stored in files and the software programs that update and maintain those files. Any change in data organization or format requires a change in all the programs associated with those files.

There is 1 question to complete.