Which property of a DBMS lets you change the database structure without requiring you to change the programs that access the database?
A) field independence
B) data integrity constraints
C) key integrity constraints
D) data independence

Question

Quizplus · Accepted Answer

Data independence is the property of a DBMS that allows changes to the database structure without affecting the application programs that access the database. This means that modifications can be made to the schema without affecting the way data is accessed, manipulated or queried by application programs. This enhances flexibility, and makes it easier and less costly to maintain and evolve the database over time. Field independence pertains to the ability of a DBMS to separately manipulate the fields or columns of a table without affecting the other fields or columns. Data integrity and key integrity constraints refer to rules that ensure the accuracy, consistency and validity of data entries in the database, but do not necessarily guarantee data independence.

Which Property of a DBMS Lets You Change the Database