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

Multiple Choice

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.