Which concept allows changes in the physical storage of data without affecting the logical structure of the database?

Options

  • A. Logical data independence
  • B. Physical data independence
  • C. Data redundancy
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Physical data independence

Detailed Explanation

  • Physical data independence: Allows changes in physical storage without requiring changes to the conceptual schema.
  • Examples include changing file organization or storage devices.
  • Logical data independence: Allows changes in the conceptual schema without affecting external views.