Supplier number is least likely to be a foreign key in:
A)Order Goods
B)Pay for Goods
C)Receive Goods
D)Warehouse

Question

Quizplus · Accepted Answer

Supplier number is most likely to be a foreign key in Order Goods, Pay for Goods and Receive Goods tables, as those tables are associated with the act of purchasing goods from a supplier. Warehouse table may also have a supplier number, but it would not be a foreign key, as it is not directly related to the act of purchasing goods from a supplier, but rather to the storage of those goods.

Supplier Number Is Least Likely to Be a Foreign Key