Data Base Management Systems

Course Project

$-$ Part $2-$

In this part, you will continue the works of part $1$ by designing Functional Dependency $($FD$),$ and Normalization.

Part $1$: Functional Dependency $(2$ Marks$)$

$-$ List all the Functional Dependency $($FD$)$ from the relation schema in project part$1.$

$-$ Explain the type of Functional Dependency $($FD$)$ you find $($e$.$g$.,$ Full, Partial, and Transitive$).$

Part $2$: Normalization $(3$ Marks$)$

Apply the Normalization process for the relational schema from part $1$ and consider Functional Dependency. You should apply the three normal forms: First Normal Form $(1$NF$),$ Second Normal Form $(2$NF$),$ and Third Normal Form $(3$NF$).$

Submission Guidelines:

$-$ You have to write a report that explains the details of each part.