You are here

Logical data independence

19 October, 2015 - 10:16

The ability to change the logical (conceptual) schema without changing the External schema (User View) is called logical data independence. 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.

In other words, if the logical schema changed, i.e. changes to the structure of the database like adding a columns or other tables, should not affect the functioning of the application (external views).

Source: http://cnx.org/content/m28150/latest/