$1.$ Normalize for inventory management system, identify dataset by applying UNF, $1$NF$,2$NF

and $3$ NF $(10$ marks$)$

$2.$ Analyze and document the Tables and functional dependencies between the table by identifying

PKs$,$ FKs and composite Keys. Establish a relationship between the table$($ER Diagram$)$

$(10$ marks$)$

$3.$ Include both your normalized relational dataset as well as finalized tables with relationship into

a word document. Attach a cover page with Student Name, Student ID$,$ Lecturer Name and

Submission Date and Time to Blackboard submission link for grading.