DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Logical Data Independence
|
|
Physical Data Independence
|
|
Conceptual Data Independence
|
|
User Data Independence
|
Detailed explanation-1: -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-2: -Physical Data Independence: The ability to change the internal schema without having to change the conceptual schema.
Detailed explanation-3: -a) Logical data independence is the capacity to change the conceptual schema without having to change external schemas or application programs.
Detailed explanation-4: -Physical data independence can be defined as the capacity to change the internal schema without having to change the conceptual schema. If we do any changes in the storage size of the database system server, then the Conceptual structure of the database will not be affected.