For the following relation and representative data,

1. Give an example of an insertion, update, and deletion anomaly.
2. Split the relation into as many 3NF relations as are necessary.

EMPLOYEE (EMPNO, EMPNAME, TITLE, COURSE_TAKEN_ID, CNAME)

EID EMPNO EMPNAME TITLE TAKEN_ID COURSENAME

1 10 JIM PROGRAMMER1 WP Web Programming

2 10 JAMES PROGRAMMER1 PM Proj Management

3 10 JIM PROGRAMMER2 OSL Op Systems/Linux

4 31 MARY DBA PM Proj Management

5 31 MARY PROGRAMMER DB Database Admin

6 20 SUE ADMIN OS Office Skills

EMPNO -> EMPNAME

EMPNO -> TITLE

COURSE_TAKEN_ID -> CNAME