The following is a database table called Students SNo Name Email Phone Address CourseName College 111 Joe Bloggs joebloggs@bloggs.com 123456 Limerick BBSFFM Griffith College 112 Joe Soap joesoap@soaps.ie 232323 Dublin BScCS UCD 113 Mary Bloggs marybloggs@bloggs.ie 124568 Tipperary MBSSCM LIT 114 John Soap johnsoap@soaps.com 333221 Cork HDipFFM UCC 115 Mary Soap marysoap@soaps.co.uk 654321 Leitrim MBAFT IT Sligo (i) Differentiate between deletion, update and insertion anomalies. (6 marks) (ii) Consider the table above. Is there a situation where an insert anomaly could occur? If so, describe why this anomaly could occur. (3 marks) (iii) Consider the table above. Is there a situation where a deletion anomaly could occur? If so, describe why this anomaly could occur. (3 marks) (iv) If the primary key of the table above was {Name, Email, Phone}. Give an example of a situation where an update anomaly could occur and explain why this would happen