Use the following to answer questions 4 - 5:
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 following application program will be modified to accommodate the change to the database table:
A) The bonus calculation program
B) The payroll application program
C) The personnel promotion application program
D) All of the above
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 sharing
D) Data independence
Entity Relationship Diagrams are input to the following phase of Database Development:
A) Logical Database Design
B) Conceptual Data Modeling
C) Physical Database Design
D) Distributed Database Design
The multi-step process used when creating a new system is referred to as ____.
A) The Systems Development Life Cycle
B) Data mining
C) E-R Modeling
D) SQL