DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Accomplished through a system of file folders and filing cabinets
|
|
|
Data access changes when data storage characteristics change
|
|
|
Data storage characteristics is changed without affecting the program’s ability to access the data
|
|
|
All file system programs are modified to conform to a new file structure
|
Detailed explanation-1: -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. same data stored unnecessarily in different places (i.e. islands of information).
Detailed explanation-2: -Alternatively, data independence is the characteristics of a database system to change the schema at one level without having to change the schema at the next higher level. In other words, the application programs do not depend on any one particular physical representation or access technique.
Detailed explanation-3: -Logical data independence: The ability to change the logical (conceptual) schema without changing the External schema (User View) is called logical data independence.
Detailed explanation-4: -structural independence-A data characteristic that exists when changes in the database schema do not affect data access.
Detailed explanation-5: -The characteristic that allows program-data independence and program-orientation independence is called data abstraction.