Consider Table A on the "one side" of a one-to-many relationship and Table B on the "many side" of the relationship. In the storing derived data physical database design technique, the best place to store the derived data from Table B is ____.
A) in a new column in Table A
B) in a new column in Table B
C) in a new record type in Table A
D) in a new record type in Table B
E) None of the above.

Question

Quizplus · Accepted Answer

The storing derived data physical database design technique suggests storing the derived data in a new column in the table on the "one side" of the relationship (Table A), to avoid redundancy and ensure data consistency. Storing the derived data in a new column in Table B would violate normalization rules and create redundancy. Creating a new record type in either Table A or Table B is not necessary or efficient for storing derived data.

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