Problem: $5$

Convert the following relation into normalized relation$($s$)$

Note: DID: Dept. id$,$ Dname: Dept. name, EID: Employee id$,$ Ename: Employee name,

PID: project id$,$ Pname: Project name, Btime: Time spent on project

a$)$ Normalize the above relation into $1NF,2NF$ and $3$ NF Tables with Functional Dependencies

and identify the relations with their attributes along with primary key and foreign keys.

$>$ How do you identify partial dependencies to move a relation from $1$ NF to $2$NF$?$

$>$ How can you eliminate transitive dependencies to reach $3$NF$?$

$>$ What are the repeating groups, if any, in the relation, and how do you normalize them to

$1$ NF $?$

$>$ Which attributes are functionally dependent on part of a composite key $($partial

dependency$)?$

b$)$ Are there any transitive dependencies in the relation? How can you identify them?

After normalizing to $2$ NF and $3$ NF $,$ are the resulting relations free of anomalies $($insertion$,$

update, and deletion$)?$ Justify your answer?

c$)$ Why is it important to maintain the dependencies and avoid redundancy in the normalized

relations?