The advantage of using the substituting foreign keys physical database design technique is that it is designed to ____.
A) reduce the number of joins
B) reduce the number of indexes
C) reduce the number of attributes in large, clumsy keys
D) All of the above.
E) None of the above.

Question

Quizplus · Accepted Answer

The substituting foreign keys physical database design technique is designed to reduce the number of joins required in a query by replacing large, clumsy keys with foreign keys that reference smaller tables. This technique does not necessarily reduce the number of indexes or attributes in the keys. Therefore, option A is the correct choice.

The Advantage of Using the Substituting Foreign Keys Physical Database