The following table shows details of the students marks for their respective modules for the semester.

$\backslash$table$[[$Student No$,$Student Name,Modue Code,Module Name,Grade,Lecturer Name,Lecturer Department$],[$S$1056,$John Ng$,$IT$001,$FCS$,$HD$,$Robin,School of Engineering$],[$S$1059,$Mary Chua,IT$001,$FCS$,$D$,$Annie Chew,School of Engineering$],[$S$1100,$Jack Chia,IT$001,$FCS$,$D$,$Robin,School of Engineering$],[$S$1308,$Bobby Ching,IT$001,$FCS$,$D$,$Annie Chew,School of Engineering$],[$S$1059,$Mary Chua,IT$002,$Database Systems,HD$,$Jason Ong,School of Design$],[$S$1056,$John Ng$,$IT$002,$Database Systems,D$,$Jason Ong,School of Design$],[$S$1100,$Jack Chia,IT$002,$Database Systems,C$,$Jason Ong,School of Design$],[$S$1308,$Bobby Ching,IT$002,$Database Systems,C$,$Jason Ong,School of Design$],[$S$1100,$Jack Chia,IT$003,$IDC,P$,$Robin,School of Engineering$],[$S$1056,$John Ng$,$IT$003,$IDC,D$,$Robin,School of Engineering$],[$S$1059,$Mary Chua,IT$003,$IDC,D$,$Annie Chew,School of Engineering$],[$S$1308,$Bobby Ching,IT$003,$IDC,HD$,$Annie Chew,School of Engineering$],[$S$1308,$Bobby Ching,IT$004,$ICS,D$,$Robin,School of Engineering$],[$S$1059,$Mary Chua,IT$004,$ICS,P$,$Robin,School of Engineering$],[$S$1056,$John Ng$,$IT$004,$ICS,HD$,$Robin,School of Engineering$],[$S$1100,$Jack Chia,IT$004,$ICS,HD$,$Jason Ong,School of Design$]]$

Table $1.$ Student Score Report

Please complete the following FOUR $(4)$ parts:

i$)$ Based on Table $1,$ write down the unnormalised form.

ii$)$ Identify the repeating group of attributes and transform part $($i$)$ into tables that are in $1^{st}$ Normal form. $($Explain the rationale for your decision$).$

iii$)$ Identify any partial dependencies in part $($ii$)$ and transform into tables that are in $2^{nd}$ Normal Form. $($Explain the rationale for your decision$).$

iv$)$ Identify any transitive dependencies in part $($iii$)$ and transform into tables that are in $3^{rd}$ Normal Form. $($Explain the rationale for your decision$).$

$($Please clearly state all assumptions and ensure that you have sufficient annotations$).$