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.

$$ You have to submit a Word file.

$$ Work in a group of $2-3$ students.

$$ The submission deadline: $12/12/2024$