Below is a table of a Company with the Employees, Department, Projects Information along

with a few functional dependencies. Find out the other functional dependencies & convert the

table to normalized form $(3$ NF$)$ & answer the following questions

$(35$ Marks$)$

Functional Dependencies

Proj Dyration depends on Proimb.

Budget depends on the ProjDuration

$($a$)$ What form is the table already in$?$

$($b$)$ Normalize the table to $3NF$ showing step by step procedure $(1$NF$,2$NF & $3$NF$).$

$($c$)$ Identify the primary and foreign keys in your final $3NF$ tables.