A database table consists of the following columns: employee's name, SS#, job-title, hiring-date, years-in-job, base-salary. A bonus calculation program, a personnel promotion application program, and a payroll application program all use this table. To implement a policy change in personnel promotion, the following column is added to the table: highest-college-degree. This new column is not used by the payroll program or by the bonus calculation program.
-The ability to add the new column without requiring changes to all of the application programs strongly relates to the following feature of modern database systems:
A) Nonprocedural programming
B) Transaction processing
C) Data independence
D) Data sharing

Question

Quizplus · Accepted Answer

Data independence refers to the ability to modify the database schema without affecting the application programs that use it. Adding a new column is a modification to the schema, and modern database systems are designed to provide data independence. Therefore, the ability to add a new column without changes to all of the application programs strongly relates to data independence.

A Database Table Consists of the Following Columns: Employee's Name