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

Process of adjustment of inheritance, Process of Adjustment of inheritance ...

Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.

Design of a database, Ask questioYou are the database administrator in a un...

Ask questioYou are the database administrator in a university. You have been tasked to come up with a new database for the University. Using the stages in Database Life Cycle come

Create student db and retrieve all student name in cs, Create a Student dat...

Create a Student database and Retrieve the names of all students majoring in ‘CS' Consider the following relational database: STUDENT (name, student#, class, major) COURSE (co

List the table modification commands in sql, List the table modification co...

List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

DISTIBUTED DATABASE, Define physical image of a global relation at a site

Define physical image of a global relation at a site

Self-join, Self-Join: In a self join a table is joined with itself. Let ...

Self-Join: In a self join a table is joined with itself. Let consider the following sample partial data of EMP table EMPNO ENAME MGRID

Write the queries in relational algebra, Problem: You are given the fol...

Problem: You are given the following schema 1. Flights(flno, from, to, distance) 2. Aircraft(aid, flno, aname, cruisingRange) 3. Certified(eid, aid) 4. Employees(eid, ena

What is the need for triggers, What is the need for triggers? Triggers ...

What is the need for triggers? Triggers are useful mechanisms for alerting humans or for starting particular tasks automatically when particular conditions are met.

Unrepeatable reads-problems of concurrent transactions, Unrepeatable reads ...

Unrepeatable reads : Assume T7 reads X twice during its implementation. If it did not update X itself it could be very disturbing to see a dissimilar value of X in its next read. B

State the object design for processing, State the Object Design for Process...

State the Object Design for Processing The object design phase comes after analysis and system design phase. The object design phase includes implementation details like as i

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages