NCRE Level 4 system-design analysis 113: Which option correctly applies the principle of database normalisation? Focus on databases in this variation.

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