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
Illustrate the view of software architecture A model is a semantically closed abstraction of system composes of elements. It can be visualized using any of the following five v

A relation has: Relational Schema Relation instance Relational Schema: A relational schema shows the relation's name, its attributes and the domain of every a

Define functional and multivalued dependencies.       Ans:  A functional dependency is a assets of the semantics of the attributes in a relation. The semantics point out how at

what is the need of a log in dbms

Explain Instance and schemas? Instances and schemas: Databases changes over time as the information is deleted and inserted. The collection of information stored in database

Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t

Explain the Check Clause The CHECK clause is employed to at the end of a CREATE TABLE statement specify table constraints. This is known as table-based constraint because it ap

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

A database is a set of data. But, is the data kept in a database trustworthy? To answer that query we must first answer the question. What is integrity? Integrity simply means t

define normalisation and functional dependency