To avoid update anomalies, we transformed the table into second normal form by removing partial dependencies.