Using an REA database design,which is the most likely primary key for the Inventory-Request_Goods table?
A)Product number.
B)Product number - Purchase order number.
C)Product number - Purchase requisition number.
D)Purchase order number.

Question

Quizplus · Accepted Answer

In an REA (Resources, Events, Agents) database design, the Inventory-Request_Goods table would likely involve a transaction (event) linking resources (inventory goods) to a request action (purchase requisition). Therefore, the primary key would most likely consist of a combination that includes the product number (identifying the specific inventory item) and the purchase requisition number (identifying the specific request event), making option C the most appropriate choice.

Using an REA Database Design,which Is the Most Likely Primary