Give an example of each type of anomaly that can happen in EMP_PROJ and EMP_DEPT given the two relation schemas: Insertion, update and deletion.

EMP DEPT EnameSsn Bdate Address DnumberDname Dmgr ssn EMP PROJ Ssn Pnumber Hours Ename Pname Plocation FD1 FD2 FD3 EMP DEPT Ename Smith, John B Dname 123456789 1965-01-09 731 Fondren, Houston, TX5 333445555 Franklin T. 333445555 1955-12-08 838 Voss, Houston, TX Alicia J 333446555 999887777 1968-07-19 3321 Castle Administration 987654321 Administration 987854321 333445555 333445555 Administration 987854321 Headquarters 888665555 Wallace, Jennifer S. 987654321 1941-06-20 291 Bellaire, TX Ramesh K 666884444 1962-09-15 975 FireOak, Humble, TX A. 453453453 1972-07-31 5631 Rice Jabbar, Ahmad V. 987987987 1969-03-29 980 Dallas, Houston, TX Borg, James E. 888665555 1937-110 450 Stone, Houston, TX EMP PROJ Ssn 123456789 123456789 866884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 Pname 32.5 Smith, John B 75 Smith, John 8 40.0 20.0 English, 20.0 E 10.0 10.0 10.0 Wong, Frankn TComputerization Stafford 0.0 Wong, Frankin . Reorganization Houston 30.0 Zelaya, Alicia J 10.0 Zelaya, Alicia 35.0 Jabbar, Ahmad VComputerization Stafford Ramesh K Productz Bellaire T. ProductY Productz Franklin T 10 20 30 10 10 Stafford Stafford 987987987 987987987 987654321 987654321 888665555 5.0 Jabbar, Ahmad V 20.0 Walace, Jennifer S. Newbenefits 15.0 Wallace, Jennifer S Null Stafford Stalford 30 20 20 James E. Figure 2: Sample states for EMP _DEPT and EMP PROJ