Interested to Buy Any Domain ? << Click Here >> for more details...
what is data independence exactly? give an example
- 6 Answers
- 42131 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 can we delete duplicate rows in a table?
What is the data pump import utility?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to connect to a remote server?
What are the arithmetic operations?
Explain about functional dependency and its relation with table design?
How to save query output to a local file?
How to create tables for odbc connection testing?
What are the logical operations?
Differentiate between post-database commit and post-form commit?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What privilege is needed for a user to query tables in another schema?
Explain the difference between a procedure and a function? What do you understand by those terms?
is there a tool to trace queries, like profiler for sql server?
Explain the use of record option in exp command.
