NCRE Level 4 system-design analysis 1: Which statement best describes database normalisation?

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