Data Independence is the capacity to modify a scheme definition in one level without affecting a scheme definition in a higher level.
TYPES OF DATA INDEPENDENCE
There are two kinds of data independence:
1. Physical data independence: It is the capacity to modify the physical scheme without having alteration to the conceptual schema.
For example, a change to the internal schema, such as using different file organization or storage structures, storage devices, or indexing strategy, should be possible without having to change the conceptual or external schemas.
2. Logical data independence: It is the capacity to modify the logical or conceptual scheme(user view) without having alteration in external schema.
For example, the addition or removal of new entities, attributes, or relationships to the conceptual schema should be possible without having to change existing external schemas or having to rewrite existing application programs.
