Consider Table A on the "one side" of a one-to-many relationship and Table B on the "many side" of the relationship. The "repeating groups" in Table B may be considered for merging into the related records of Table A if ____.
A) there is a large number of occurrences of the repeating groups of Table B for each record of Table A
B) there is a small number of occurrences of the repeating groups of Table B for each record of Table A
C) there is a significant number of indexes built over the repeating groups of Table B
D) All of the above.
E) None of the above.

Question

Quizplus · Accepted Answer

Repeating groups in Table B should be considered for merging into the related records of Table A if there is a small number of occurrences of the repeating groups for each record of Table A. This will eliminate redundancy and improve the efficiency of the database. Option A is incorrect because a large number of occurrences of the repeating groups does not necessarily mean they should be merged into Table A. Option C is also incorrect because the presence of indexes does not determine whether merging is necessary or not. Option D is not entirely correct as only option B is applicable. Option E is not applicable as well.

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