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

Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera

Consider entity type Employee with attributes empNumber (this is unique), empName, and the year when he/she was hired. An employee can either be a technical employee, a marketing e

Special comparison operator used in where Clause a.   between. ...and...It gives range among two values (inclusive) Example: SELECT ENAME, SAL FROM EMP WHERE SAL BETWE

Domain Constraint It shows that each attribute in a relation has to contain an atomic value only from the corresponding domains. The data types associated with commercial RDBMS

I am using Siteground. And my database is full of limit so need someone who reduces the data which no need. This is very simple and simple task. Skills required are Databa

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

Question 1 Explain ER model Question 2 What are the characteristics of a computer provided information? Question 3 What are facts and guidelines to be considered when se

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

What are the kinds of Strings?  -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt