CLOUD COMPUTING
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: -Physical Data Independence: The ability to change the internal schema without having to change the conceptual schema.
Detailed explanation-2: -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-3: -Internal schema This level defines how the data is physically stored on storage devices, such as a hard disk. It provides the complete details of physical storage and access paths.
Detailed explanation-4: -Physical Data Independence This is defined as the ability to modify the physical schema of the database without the modification causing any changes in the logical/conceptual or view/external level.