Consider the table below. For each data anomaly give an example of how the anomaly could affect the data and draw the solution (i. new table or...

Normalization and data anomalies. Please draw the solution to each.

Consider the table below. For each data anomaly give an example of how the anomaly couldaffect the data and draw the solution (i.e. new table or tables).doctor id |doctor name |patient iddiagnosisDO01SmithP101infectionDO02JonesP142herniaDO01SmithP130infectionDO03HarrisP115migrainea. Deletion Anomalyb. Insertion Anomalyc. Update Anomaly