FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

WHAT IS DATABASE MANAGEMENT

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Using different file organization should not require change to conceptual or external schemas. This is referring to
A
Logical Data Independence
B
Physical Data Independence
C
Conceptual Data Independence
D
User Data Independence
Explanation: 

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.

There is 1 question to complete.
Previous
Next