In a database containing (among others) six 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 specific to the VENDORS relation and is unique for each record representing a vendor, it is suitable to be the primary key in the VENDORS relation.

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