For the relation shown below, describe a) an insertion anomaly, b) a delete anomaly, c) a modification anomaly. The primary key of the table below is RepairNumber The following is a relation representing a soccer team database: Player (Player-1D.Plaver-Name. Player-address, Team, Color, Head-Coach) Please diagram the functional dependencies on the relation above. Label each dependency as to whether it is a full, partial or transitive dependency. Next, convert the diagram into a relational schema in 2NF in the space indicated below. Then show the relations in 3NF. labeling the referential integrity constraints. Show the 2NF schema just below this sentence, followed by the 3NF schema. 3. On the diagram below, please label each of the 3 functional dependencies shown as to whether it is a full, partial or transitive dependency. Please transform the INF diagram shown below into a set of relations in 2NF. Then show the relations in 3NF, labeling the referential integrity constraints. Label the dependencies on the diagram above. Just below this sentence, show the 2NF relations, followed by the 3NF relations