DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Logical independence
|
|
|
Physical independence
|
|
|
Logical dependence
|
|
|
None of the above
|
Detailed explanation-1: -Logical independence is a condition in which the internal model can be changed without affecting the conceptual model. The internal model is hardware-independent because it is unaffected by the computer on which the software is installed.
Detailed explanation-2: -Physical data independence: The ability to change the physical schema without changing the logical schema is called physical data independence.
Detailed explanation-3: -Physical Data independence is the capacity to change the conceptual schema without having to change external schemas or application programs. is the capacity to change the internal schema without having to change the conceptual schema.
Detailed explanation-4: -A conceptual model is a representation of the system expertise using this formalism. An internal model is derived from the conceptual model and from a specification of the system transactions and the performance constraints. The internal model is a complete system specification.