NCRE Level 3 systems and network task 7: Which statement best describes database normalisation?

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