Dbms logical dependance

47 %
53 %
Information about Dbms logical dependance
Business & Mgmt

Published on March 15, 2014

Author: TejKiran2

Source: slideshare.net

Physical and Logical data Independence

Logical Data Independence

What do you mean by logical data independence? The ability to change the logical schema without changing the external schema or application programs is called as Logical Data Independence. OR The ability to change the logical schema without having to change the external schema.

Examples The addition or removal of new entities, attributes, or relationships to the conceptual schema should be possible without having to change existing external schemas or having to rewrite existing application programs.

Physical Data Independence

What do you mean by Physical Data Independence  The ability to change the physical schema without changing the logical schema is called as Physical Data Independence. Changes in the physical schema may include.  Using new storage devices.  Using different data structures.  Switching from one access method to another.  Using different file organizations or storage structures.  Modifying indexes.

Examples A change to the internal schema, such as using different file organization or storage structures, storage devices, or indexing strategy, should be possible without having to change the conceptual or external schemas.

Entity Relationship

Elements of E-R Model  In the E/R model, the structure of data is represented graphically, as an “entity-relationship diagram,” using three Principal element types:  Entity Sets.  An entity is an abstract object of some sort, and a collection of similar entities forms an entity set.  Attributes  The properties of the entities in the set.  Relationship  The connections among two or more entity Sets

Example of Elements of E-R Model Entity Sets Departments Professors Students Administrators Attributes Name of Departments, Phone No., Address... Name, SSN, Address of Professors... Relationship Students and Professors are under a certain department Admin manage the campus/ departments

Attribute  An attribute is an item of data held about an entity  In computer systems an attribute is a field of information  Example : Sales System  Entity : Customer  Attributes : Customer Name, Customer Address, Customer Phone Number

 A key attribute uniquely identifies a specific occurrence of an entity  This may also be referred to as a primary key  Examples of primary keys include:  ISBN  Student Number  Staff ID  In a Sales System, customer name and address are attributes of the entity customer.  The primary key is likely to be Customer Code or Customer ID as the unique identifier for each customer in the system. For Example

Example: A library database contains a listing of authors that have written books on various subjects (one author per book). It also contains information about libraries that carry books on various subjects. Entity sets: authors, subjects, books, libraries Relationship sets: wrote, carry, indexed carry books indexwrote subjectauthors SS# name title libraries quantity address isbn Subject matter


Example of the 3 elements in Entity Relationship Diagram Entity B Relationship Attribute Entity C Entity A Attribute Attribute

Add a comment

Related presentations

Related pages

Data independence - Wikipedia, the free encyclopedia

Data independence is the type of data transparency that matters for a centralised DBMS. ... Logical Data independence means if we add some new columns or ...
Read more

The difference between logical and physical ... - blogspot.com

The difference between logical and physical data independence ... Why does a DBMS interleave the actions of differen... Transaction;
Read more


DIFFERENCE BETWEEN PHYSICAL AND LOGICAL DATA INDEPENDENCE One of the biggest advantages of database is data independence. ... DBMS Assignments; Blog Archive
Read more

What Logical data independence and physical data ... - Answers

Logical Data Independence : The ability to change the logical schema without changing the external schema or application programs is called as.
Read more

About Logical Data Independence - Revision-Zero

... I wanted to write somewhing about what has been called 'logical data independence' but I ... few DBMS provide a good view ... DBMS to manage logical ...
Read more

Data Independence - Computer Science at UVA

Data Independence DBMS approach-real solution: data abstraction ... Logical data independence-the capacity to change the conceptual schema without
Read more

DBMS - Data Independence - Tutorialspoint

DBMS Data Independence - Learn DBMS in simple and easy steps starting from its overview, Architecture, data models, data schemas, data independence, ED ...
Read more

What is Data Independence? Webopedia Definition

The separation of data from the programs that use the data. Nearly all modern applications are based on the principle of data independence.
Read more