1. A file has r=20,000 STUDENT records of fixed-length.
Each record has the following fields: NAME (30 bytes), SSN (9 bytes), ADDRESS (40 bytes), PHONE (9 bytes), BIRTHDATE (8 bytes), SEX (1 byte), MAJORDEPTCODE (4 bytes), MINORDEPTCODE (4 bytes), CLASSCODE (4 bytes, integer), and DEGREEPROGRAM (3 bytes).
An additional byte is used as a deletion marker.
Block size (512 bytes)
a) Calculate the record size R in bytes.
b) Calculate the blocking factor bfr and the number of file blocks b assuming an unspanned organization.
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 personnel promotion application program
C) The payroll 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 independence
D) Data sharing
D
Order an Essay Now & Get These Homework Help Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
