In a database containing (among others) five relations--VENDORS, PURCHASE_REQUISITIONS, PURCHASE_ORDERS, PURCHASE_RECEIPTS, INVENTORY, and EMPLOYEES--you would expect that the attribute Vend_No (vendor number) would be the primary key in the ____ relation.
A)VENDORS
B)PURCHASE_ORDERS
C)PURCHASE_RECEIPTS
D)EMPLOYEES

Question

Quizplus · Accepted Answer

Since the attribute Vend_No (vendor number) is specifically related to the VENDORS relation, it should be the primary key in that relation. It would not make sense for it to be the primary key in any of the other relations since they are not directly related to vendors.

In a Database Containing (Among Others) Five Relations--VENDORS, PURCHASE_REQUISITIONS, PURCHASE_ORDERS