NCRE Level 3 systems and network task 105: Which option correctly applies the principle of database normalisation? Focus on databases in this variation.

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