The capacity to change the conceptual schema without having to change the…
2023
The capacity to change the conceptual schema without having to change the external schemas or additional programs is called as __________.
- A.
Physical Data Independence
- B.
Lateral Data Independence
- C.
Posterior Data Independence
- D.
Logical Data Independence
Attempted by 598 students.
Show answer & explanation
Correct answer: D
Logical Data Independence refers to the ability to change the conceptual schema of a database without affecting the external schemas or application programs. This means that modifications to the logical structure of the database, such as adding or removing tables or attributes, can be made without requiring changes to the user views or application code. This independence ensures that the database remains flexible and maintainable, allowing for schema evolution without disrupting existing applications.