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
Concurrency Identification While designing analysis, model we map real world model into our analytical model. Real life objects are simultaneous in nature, but all the design

What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p

What is the most significant feature that does not directly map into programming language structures? Why? Association, since there are complex types of association, like as qu

Physical Database Design Issues The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

The domain that you will model in this assignment is that of courses and students at a university. So as not to make the task too large and unspecified, you will here get a descrip

Develop Database academic assignment Project Description: For a provided set of instructions in a case study design Entity Relationship Diagram. - Entity Relationship Diag

If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

What is difference between TRUNCATE and DELETE? - Truncate can't be rolled back whereas Delete can be. - Truncate keeps the lock on table whereas Delete keeps the lock on ea

In a Hierarchical model of data records are organized ? In the hierarchical model of data records are organized as Tree structure.

List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im