Given the following master file containing employee names (key field) and hourly rates and given the following transaction file, how many total records will there be in the updated master file?

Master File Transaction File
John 20.00 Add Jim 11.00
Mary 10.00 Delete John
Sue 6.00 Add Nancy 15.00
Tom 8.00 Delete Tom
Vince 13.00 Add Tom 13.00
Change Vince 14.00

a) 5
b) 6
c) 7
d) 8

b) 6

Computer Science & Information Technology

You might also like to view...

The Mark as Final protect document category enables you to add an invisible digital signature to a document to ensure its integrity

Indicate whether the statement is true or false

Computer Science & Information Technology

Answer the following statements true (T) or false (F)

1. An attribute contains entities. 2. An output report must have the same fields and in the same order as the database table. 3. A query uses conditional expressions to select data. 4. Queries build a new table by selecting all or part of the records and/or fields. 5. Forms allow the user to see all of the data for one record at one time on the screen.

Computer Science & Information Technology