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 requisition number

Question

Quizplus · Accepted Answer

In an REA database design, it is important to choose a primary key that uniquely identifies each record in the table. In the case of the Inventory-Request_Goods table, the primary key should identify a specific request for goods from inventory. Both the purchase requisition number and product number are necessary for identifying a specific request, so a combination of both would be the most appropriate primary key. Choice C provides both the product and purchase requisition numbers, making it the best option. Choices A and D do not include the purchase requisition number, while choice B includes the purchase order number, which is not necessary for identifying a specific request for goods from inventory.

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