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?
$$\begin{array} { l l l l l }
\text { Master File } & & { \text { Transaction File } } & \
\text { John } & 20.00 & \text { Add } & \text { Jim } & 11.00 \
\text { Mary } & 10.00 & \text { Delete } & \text { John } & \
\text { Sue } & 6.00 & \text { Add } & \text { Nancy } & 15.00 \
\text { Tom } & 8.00 & \text { Delete } & \text { Tom } & \
\text { Vince } & 13.00 & \text { Add } & \text { Tom } & 13.00 \
& & \text { Change } & \text { Vince } & 14.00
\end{array}$$
A)5
B)6
C)7
D)8

Question

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?
$$\begin{array} { l l l l l } 
\text { Master File } & & { \text { Transaction File } } & \
\text { John } & 20.00 & \text { Add } & \text { Jim } & 11.00 \
\text { Mary } & 10.00 & \text { Delete } & \text { John } & \
\text { Sue } & 6.00 & \text { Add } & \text { Nancy } & 15.00 \
\text { Tom } & 8.00 & \text { Delete } & \text { Tom } & \
\text { Vince } & 13.00 & \text { Add } & \text { Tom } & 13.00 \
& & \text { Change } & \text { Vince } & 14.00
\end{array}$$
A)5
B)6
C)7
D)8

Quizplus · Accepted Answer

From the master file, we know that there are 4 employees listed. Each of the 4 transactions in the transaction file matches an employee in the master file, so each transaction will update an existing record in the master file. Therefore, there will still be 4 records in the master file after the updates. Additionally, there is 1 transaction in the transaction file that represents a new employee that is not listed in the master file. This transaction will add a new record to the master file, bringing the total number of records in the updated master file to 5. Finally, one of the transactions in the transaction file represents an employee who is no longer with the company. This transaction will not have any effect on the master file, so the total number of records in the updated master file remains at 5.

Therefore, the total number of records in the updated master file is 5 + 1 (new employee) = 6.

Thus, the best choice is B)6.

Given the Following Master File Containing Employee Names (Key Field)and