Consider Table A on the "one side" of a one-to-many relationship and Table B on the "many side" of the relationship. The primary key of Table A has been placed in Table B as a foreign key. The substituting foreign keys physical database design technique ____.
A) can be performed if Table A has only one candidate key
B) cannot be performed if Table B has only one foreign key
C) can only be performed if Table A has more than one candidate key
D) can only be performed if Table B has more than one foreign key
E) None of the above.

Question

Quizplus · Accepted Answer

The substituting foreign keys physical database design technique can only be performed if Table A has more than one candidate key. This is because the foreign key in Table B must be able to uniquely identify a row in Table A, and if Table A has only one candidate key, then the foreign key in Table B will not be able to do this.

Consider Table a on the "One Side" of a One-To-Many