NCRE Level 4 system-design analysis 57: Which conclusion about database normalisation is most accurate? Focus on databases in this variation.

A. Normalisation reduces avoidable redundancy and update anomalies B. It removes all keys C. It guarantees that no query uses a join D. Normalisation copies every value into every table