1.

What do you understand about Data Independence in the context of DataBase Management Systems (DBMS)?

Answer»

In Database Management Systems (DBMS), data independence implies that the application is independent of the storage structure and data ACCESS mechanism. It allows you to change the schema definition at one level without having to change the schema definition at the next level up.

Data independence can be divided into two categories:

  • Physical Data Independence: The data CONTAINED in the database is referred to as physical data. It's in a binary format. Physical changes should not have an impact on the logical level. For example, if we wish to edit data WITHIN a table, we shouldn't change the table's format.
  • Logical Data Independence (LDI): The ability to update the CONCEPTUAL schema without having to change the external schema is referred to as logical data independence. To distinguish the external level from the conceptual view, logical data independence is used. Any modifications to the conceptual representation of the data will not AFFECT the user’s view of the data.


Discussion

No Comment Found

Related InterviewSolutions