epartment of Computer Sciences

Cs $340-$ Introduction to Database Systems

Instructor Name: Dr$.$ Maram Ajlan $/$ Ms$.$ Raohi Jan

Datced: ${14}^{th}$ May $2024$

Question $2$: Functional Dependencies and normalization $[3$ marks$]$

Given below is Emp$\_$Proj relation

EMP$\_$PROJ $($Proj Num, Project Name, Emp No$,$ Emp Name, Job Class, Chg$/$Hr$,$ HRS Billed, Total Charge$)$

The following are the functional dependencies that hold in the EMP$\_$PROJ relation are:

Proj Num $$ Project Name

Emp No $$ Emp Name, Job Class

Job Class $$ Chg$/$Hr

$($Proj Num, Emp No$)$ HrsBilled, Total Charge

EMP$\_$PROJ

$\backslash$table$[[\backslash$table$[[$Proj$],[$Num$]],\backslash$table$[[$Project$],[$Name$]],$Emp No$,\backslash$table$[[$Emp$],[$Name$]],$Job Class,$Ch\frac{g}{H}r,\backslash$table$[[$Hrs$],[$Billed$]],$Total Charge$],[13,$Banking,$\backslash$table$[[103],[105]],\backslash$table$[[$Ramesh$],[$Ram$]],\backslash$table$[[$System$],[$Analyst$],[$Programmer$]],\backslash$table$[[500],[300]],\backslash$table$[[8],[8]],\backslash$table$[[4000],[2400]]],[26,$Telecom,$\backslash$table$[[115],[717]],\backslash$table$[[$Amit$],[$Shyam$]],\backslash$table$[[$Business$],[$Analyst$],[$Engineer$]],\backslash$table$[[100],[300]],\backslash$table$[[10],[7]],\backslash$table$[[1000],[2700]]],[39,$Finance,$\backslash$table$[[113],[120]],\backslash$table$[[$Gopal$],[$Suresh$]],\backslash$table$[[$Team$],[$Leader$],[$DBA$]],\backslash$table$[[1000],[800]],\backslash$table$[[4],[3]],\backslash$table$[[4000],[2400]]],[40,$Banking,$\backslash$table$[[103],[113]],\backslash$table$[[$Ramesh$],[$Gopal$]],\backslash$table$[[$System$],[$Analyst$],[$Team leader$]],\backslash$table$[[500],[1000]],5,\backslash$table$[[2500],[5000]]]]$

$($i$)$ Identify one insertion, and deletion anomalies in EMP$\_$PRO$)$ relation.

Term $-242($Spring $2024)-$ Version $2$

Page $3$ of $4$