How many types of data independence have, Database Management System

Types of data independence

Data independence can be classified into the following two types:

Physical Data Independence: This means that for any change made in the physical schema, the requirement to change the logical schema is minimal. This is practically simpler to achieve.

Logical Data Independence: This means that for any change made in the logical schema, the requirement to change the external schema is minimal. As we shall see, this is a little complex to achieve.

 

Posted Date: 7/26/2013 5:33:59 AM | Location : United States







Related Discussions:- How many types of data independence have, Assignment Help, Ask Question on How many types of data independence have, Get Answer, Expert's Help, How many types of data independence have Discussions

Write discussion on How many types of data independence have
Your posts are moderated
Related Questions
Explain the utilities which help the DBA to manage the database? Every DBA uses database utilities to maintain and control their databases. But there is a lot of confusion wit

Australian Bureau of Statistics (ABS) provides retail data for different groups and different states as well as the aggregate numbers. Table 11 " Retail Turnover, State by Industry

Eliminate Columns Not Dependent On Key The Employee Relation satisfies - First normal form - As it has no repeating groups. Second normal form - As it do not have multi-a

Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and

Forward Recovery (Redo): In this system the committed changes made by a transaction are reapplied to a previous copy of the database.                          In simpler

What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM

What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)

In the architecture of a database system which external level used? In the architecture of a database system view external level used.

Normal 0 false false false EN-US X-NONE X-NONE

What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.