A student is analyzing Physical Design and Tuning. Which statement about normalization trade-off is correct?

Correct Answer: D

normalization reduces redundancy but may require joins that affect performance

This statement is correct because normalization trade-off means that normalization reduces redundancy but may require joins that affect performance.