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

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