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

question 8

Multiple Choice

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