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
What is Structured Query Langauge (SQL)? SQL is a powerful set-oriented language which was formed by IBM research for the databases that adhere to the relational model. It havi

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

Define the Immediate Update The immediate update methods may apply changes to the database on disk before the transaction arrives a successful conclusion. Though, these change

Relational and E-R Model There are three types of constraints on relational database that have: DOMAIN CONSTRAINT PRIMARY KEY CONSTRAINT INTEGRITY CONSTRAINT

Consider the following database schema: STAFF(StaffNo, fName, lName, Position, sex, dob, branchNo) BRANCH(BranchNo, Street, City) Assume the following for the above database

Discuss the differences among the candidate keys and the primary key of a relation. Give instance to describe your answer? A candidate key is one that can be used as primary ke

FDs in Relationships:  Enrols Relationship: None as it is many to many Teaches Relationship : Course code → Instructor Instructor → Course code The next question is:

What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.