Define data independence, Database Management System

Assignment Help:

Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in one level could not change the schema definition in the next higher level. Two kinds of Data Independence:

Physical Data Independence: Change in physical level could not affect the logical level.
Logical Data Independence: Change in logical level could affect the view level.

1540_Data Independence.png

Related Discussions:- Define data independence

Describe physical data independence, Describe Physical Data independence ? ...

Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter

The basic 2pl-two phase locking (2pl), Normal 0 false false ...

Normal 0 false false false EN-US X-NONE X-NONE

Write a query to find name from the relational algebra, Consider the relati...

Consider the relations City (city_name, state) Hotel (name, address) City_hotel (hotel_name, city_name, owner) Answer the following queries in relational algebra (i) Find

A database administrator'', A database administrator''s responsibilities an...

A database administrator''s responsibilities and data contents

Difference between sql and sqlplus, Difference between SQL and SQLPlus ...

Difference between SQL and SQL*Plus SQL SQL*Plus SQL is a language SQL *Plus is an environment It is bas

What is a query tree, What is a query tree? Ans: A query tree, as ...

What is a query tree? Ans: A query tree, as well known as operator graph, is a tree data structure that corresponds to a relational algebra expression. It denotes the inpu

Integrity of a database enforced by integrity rules, Question: This Que...

Question: This Question refers to the database schema given in the Appendix. (a) The integrity of a database is enforced by integrity rules. Discuss what should happen on a

Explain weak and strong entity type, Explain weak and strong entity type ? ...

Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea

What is entity in dbms, What is entity in DBMS? Entity: A DBMS entity i...

What is entity in DBMS? Entity: A DBMS entity is either a thing in the modelled world or a drawing element in an ERD.

Describe logical data independence, Describe logical data independence ? ...

Describe logical data independence ? Logical Data Independence - It is the capacity to modify the conceptual schema without having to change external schemas or application p

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages