NCRE Level 3 systems and network task 42: Which statement should guide analysis 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