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

Sparse and dense indexes, Sparse and Dense Indexes These indexes in pri...

Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged

Problem about data mining for business intelligence, Do the 11.1 11.1 Cre...

Do the 11.1 11.1 Credit Card Use. Consider the following hypothetical bank data on consumers’ use of credit card credit facilities in Table 11.3. Create a small worksheet in Exce

Determine the term- active values, Determine the term- Active values An...

Determine the term- Active values An active value is that has dependent values. Every dependent value registers itself with active value that contains a set of dependent values

gaps in sequence values can happen when-sequences, Gaps in sequence values...

Gaps in sequence values can happen when: - A rollback happens that is when a statement changes are not accepted. - When the system crashes - When a sequence i

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

Define physical image of a global relation at a site

Insert - referential integrity, The insertion of a tuple in the aim of refe...

The insertion of a tuple in the aim of reference does not cause any destruction. Though, insertion of a tuple in the relation in which, we has the foreign key, for instance, in ASS

Fragmentation-design of distributed databases, Fragmentation: It is defini...

Fragmentation: It is definite as partitioning of a relation into various fragments.Every fragment can be stored at a dissimilar site.

Develop a flowchart using the decision structure, 1. Develop a flowchart u...

1. Develop a flowchart using the decision structure to solve the following problem. A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches

What is oom, What is OOM? Object oriented modeling is an approach by wh...

What is OOM? Object oriented modeling is an approach by which modeling of systems is done by visualizing the system based on real world concepts. Object oriented modeling does

Remove all transitive dependencies - dependency diagram, 1. Use the Invoice...

1. Use the Invoice table structure shown below to answer the following questions: a) Draw the dependency diagram and identify the primary key and all dependencies, including al

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