Consider the following REA model as you answer the question: Which of the following would be foreign keys in the "purchase inventory" table?
A)Supplier ID
B)Employee ID
C)Both supplier ID and employee ID
D)Neither supplier ID nor employee ID

Question

Consider the following REA model as you answer the question:  Which of the following would be foreign keys in the "purchase inventory" table?
A)Supplier ID 
B)Employee ID 
C)Both supplier ID and employee ID 
D)Neither supplier ID nor employee ID

Quizplus · Accepted Answer

In the REA model, "purchase inventory" is a bridge table that links the "purchase" and "inventory" tables. The foreign keys in this table would be the primary keys of the "purchase" and "inventory" tables. Therefore, both Supplier ID and Employee ID should be foreign keys in the "purchase inventory" table.

Consider the Following REA Model as You Answer the Question