Which option best describes the use of normalization trade-off in a database system?

A. normalization is only a security technique B. normalization reduces redundancy but may require joins that affect performance C. normalization always eliminates all joins D. normalization applies only to MongoDB indexes