Question

Difference b/w logical or physical independence in dbms

Answer 1

Hello...

Answer : The notion of logical data independence refers to the fact that the parts of the SQL schema that deal with the logical schema can be changed without breaking the SQL queries over the user views. ... Physical data independence is the ability to modify the physical schema without causing application programs to be rewritten.

#FollowMe

Answer 2

It means we change the physical storage/level without affecting the conceptual or external view of the data. ... Only the physical schema or the storage is altered but the table view remains unaltered. Logical data independence is the ability to modify the logical schema without having to rewrite the application program.