what is data independence exactly? give an example
- 6 Answers
- 42476 Views
- I also Faced
- E-Mail Answers
Answer Posted / sravya
There are two types of data independence
1. Logical data independence: The ability to change the
logical (conceptual) schema without changing the External
schema (User View) is called logical data independence. For
example, 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.
2 Physical data independence: The ability to change the
physical schema without changing the logical schema is
called physical data independence. For example, 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.
| Is This Answer Correct ? | 127 Yes | 11 No |
Post New Answer View All Answers
How to use values from other tables in update statements using oracle?
How to put more than 1000 values into an oracle in clause?
Design database draw er diagram for a certain scenario ?
How to select all columns of all rows from a table in oracle?
What is oracle latest version?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to start an oracle instance?
How to write a left outer join with the where clause in oracle?
