Given the following master file containing employee names (key field)and hourly rates and given the following transaction file,what is the value of Tom's hourly rate 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)8
B)13
C)14
D)21

Question

Given the following master file containing employee names (key field)and hourly rates and given the following transaction file,what is the value of Tom's hourly rate 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)8
B)13
C)14
D)21

Quizplus · Accepted Answer

Looking at the transaction file, we can see that Tom's hourly rate has been updated to 13. Therefore, the value of Tom's hourly rate in the updated master file is 13.

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