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

---

Definitions:

Economic Theory

A conceptual framework explaining how economies operate, including principles on production, distribution, and consumption of goods and services.

Product Supply

The total amount of a product or service that is available for purchase by consumers at a given price point and time.

Quantity Demanded

The total amount of a good or service that consumers are willing and able to purchase at a specific price level.

Market Equilibrium

is the state in which market supply equals market demand, resulting in stable prices where the quantity of goods supplied equals the quantity of goods demanded.