What is the meaning of data independence, Database Management System

Assignment Help:

What is the meaning of Data Independence?

Related Discussions:- What is the meaning of data independence

Construct a conceptual data model, Competition entrants can be either Indiv...

Competition entrants can be either Individuals, or Teams. A Team is usually sponsored by a business, and, in that case, the team members would all wear T-shirts with the sponsoring

Create a table for database transformation , Step 1 . Using Oracle, create ...

Step 1 . Using Oracle, create the tables identified in the preferred solution for Assignment 2. Technicians (ZipCode, TechnicianID, FirstName, LastName, Street, City, State, Home

State the objectives of object design, Determine the OBJECTIVES of object ...

Determine the OBJECTIVES of object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl

Get details of employee working on both comp354 and comp345, Consider the r...

Consider the relations EMPLOYEE(emp#, name) ASSIGNED_TO(project#, emp#) PROJECT(project#, project_name, chief) Express the subsequent queries in Relational Algebra (i) Ge

Cube building in dataware housing , 1) Define a job scheduling strategy tha...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Cobol program, non numeric literals

non numeric literals

Tour Operator Agency Database , #A multinational tour operator agency has g...

#A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont

Sql query for testing triggers and stored procedures , Demonstrate your kno...

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Explain natural join, Explain natural join? Natural Join - Similar as...

Explain natural join? Natural Join - Similar as equi-join except in which the join attributes (having similar names) are not involved in the resulting relation. Only one sets

Equi-join, explain equi-join using illustration

explain equi-join using illustration

12/5/2013 4:22:59 AM A() *Data Independence*: The ability to adjust a schema definition in one level without effecting a schema definition in next level is known as Data Independence. There are two levels of data independence as following: a() Physical Data Independence: The skill to modify the physical schema with no causing application programs to be rewritten. b() Logical Data Independence: The facility to modify the conceptual schema lacking causing Application programs to be rewritten. Logical Data Independence is additional difficult to achieve than physical data independence because application programs are heavily dependent on the logical structure of the data they access.

12/5/2013 4:22:59 AM

A() Data Independence: The ability to adjust a schema definition in one level without effecting a schema definition in next level is known as Data Independence.

There are two levels of data independence as following:

a() Physical Data Independence: The skill to modify the physical schema with no causing application programs to be rewritten.

b() Logical Data Independence: The facility to modify the conceptual schema lacking causing
Application programs to be rewritten. Logical Data Independence is additional difficult to achieve than physical data independence because application programs are heavily dependent on the logical structure of the data they access.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages