Define data independence, Database Management System

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

Posted Date: 7/30/2012 1:35:59 AM | Location : United States







Related Discussions:- Define data independence, Assignment Help, Ask Question on Define data independence, Get Answer, Expert's Help, Define data independence Discussions

Write discussion on Define data independence
Your posts are moderated
Related Questions
NEED FOR A DATABASE MANAGEMENT SYSTEM A Database is a structured, persistent collection of data of an organisation. The database management system (DBMS) manages the database o

Define the Division Operation of Relational Algebra Let R be a relation comprising attributes (A1,...Ap,Ap+1,...An) and S comprising attributes (Ap+1,...An)  DEF: Division

Question : (a) Differentiate between database integrity and database security (b) Database security involves measures to avoid loss of privacy and loss of confidentiality. D

What is MySQL? MySQL is a relational database management system which has eleven million installations. It can be used for both Linux and Window. Managing database includes add

Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica

Sub query in the UPDATE command : Example :  //Double  the  commission  for  employees,  who  have  got  at  least  2 increments. UPDATE EMP SET COMM = COMM * 2 WHERE

Compute the closure (F+) for the following set of the functional dependencies defined on R(a,b,c,d), where F - {c→ a, ab → d, a → b, d → c}, i.e. what are all of the FDs implied b

What is schema

Write short notes on Schema diagram.  A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema  diagram. Every relation appea