Question$-5[10$marks$]$

The table shown b elow having schema $($herolD$,$ teamiD, heroName, teamName, joinYear$)$ is an easy target for update anomalies. Provide examples of insertion, deletion, and modification anomalies.

$\backslash$table$[[$heroId$,$teamID,heroName,teamName,joinYear$],[1,1,$Thor,The Avengers,$1963],[2,2,$Mister Fantastic,Fantastic Four,$1961],[3,1,$Iron Man,The Avengers,$1963],[4,1,$Hulk,The Avengers,$1963],[5,1,$Captain America,The Avengers,$1964],[6,2,$Invisible Girl,Fantastic Four,$1961]]$