In the adding new tables physical database design technique ____.
A) subsets of the most heavily accessed portions of existing tables can be copied and created as new tables
B) entire tables can be copied and new tables created
C) data redundancy across tables is traded-off against improved performance
D) All of the above.
E) None of the above.

Question

Quizplus · Accepted Answer

All of the options describe valid techniques in the physical database design process for adding new tables. These techniques aim to improve performance by creating subsets or copies of tables and accepting some level of data redundancy.

In the Adding New Tables Physical Database Design Technique ____