Explain data independence, Database Management System

Assignment Help:

Explain data independence ?

Data independence is the capacity to modify the schema at one stage of a database system without having to change the schema at the further level. The three-schema architecture permits the feature of data independence. Data independence occurs since while the schema is changed at a few level, the schema at the further level remains unchanged; only the mapping among the two levels is changed.

Related Discussions:- Explain data independence

Define an operator that a relational algebra does not have, Define an opera...

Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.

Er model, There are a number of possible solutions to the open ended brief....

There are a number of possible solutions to the open ended brief. One of the simple ones is shown here without the PKs and FKs. It is important to think of how a number of tasks

The locking protocol, The Locking Protocol: To manage concurrency related ...

The Locking Protocol: To manage concurrency related problems we use locking. A lock is mainly a variable that is associated with a data item in the database. A lock can be located

Incident report to the database, The Form input elements are: ...

The Form input elements are: Reporter name text type input Password

Advantages to copying records from one table to another, What kind of advan...

What kind of advantages to copying records from one table to another? -) When an algorithm that modifies a table is used after that it's safer to work with the copy -) When

Primary key, The primary key is selected from the

The primary key is selected from the

What is object containment, What is object containment? References amon...

What is object containment? References among objects can be used to model dissimilar real-world concepts.

Draw the dependency diagram for the relation, Consider the subsequent relat...

Consider the subsequent relation Professor (Pfcode, dept, head, time) It is assumed that (i) A professor can work in much more than one

Properties of a transaction , Properties of a Transaction A tra...

Properties of a Transaction A transaction has four main properties. These are: Atomicity Consistency Isolation or Independence Durability or Permanen

Which operation is used if we are interested certain columns, Which operati...

Which operation is used if we are interested in only certain columns of a table? PROJECTION operation is used if we are interested in only certain columns of a table.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages