The following relation Student exhibits the so - called update anomalies . S SSN Address | $ Class\ Course No\ | offersen\ | offerY's |...

The following relation "Student" exhibits the so-called update

anomalies.

1 .The following relation" Student" exhibits the so - called updateanomalies .S SSNAddress | $ Class\Course No\| offersen\| offerY's | 5 Grade | [ Des234891567Clinton2019CSC 6 20Fall20163. 2VB456123789Jackson| 2019CSC 6 20Fall20163. 2VB234891567Clinton*2019C$0541Spring20173.0456123789Jackson*| 2019CSC` 20\ Fall20163.4DB1 ) |Give an example using the above relation to explain the insertion anomaly .2) Give an example using the above relation to explain the modification anomaly .3 ) Give an example using the above relationation to explain the deletion anomaly*2 .Answer the following questions about normalization .a ) Define IN F ( second normal form ) and give an example to illustrate .6 ) Consider the following relation schema and functional dependencies ?Car_ Sale ( Car ID. Date_ sold . Salesman ID. Commission , Discount )FD1 : Salesman ID > CommissionFD 2 : Date sold > Discount1 )Is the Car Sale relation schema in INE ? Explain your answer .2)Is the Car_ Sale relation schema in 2 NF ? Explain your answer .FriIs the Car_ Sale relation schema in 3 NE ? Explain your answer .4 )If the relation schema is not in 3 NE , then transform it into a set of relationschemas such that each resulting relation schema is in 3 NE .3 .Consider the relation R. ( A. B. C, D. E] and the set of FD as follows*FDI : AB > EFD 2: D - Ca ) Find all the keys6 ) Decompose R into BCNF . Show Your work for partial credit .