Part A: Data Anomalies

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

doctor_id	doctor_name	patient_id	diagnosis
D001	Smith	P101	infection
D002	Jones	P142	hernia
D001	Smith	P130	infection
D003	Harris	P115	migraine

a. Deletion anomaly

b. Insertion Anomaly

c. Update Anomaly