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$],[$$$1056,$John $Ng,$IT$001,$FCS$,HD,$Robin,School of Engineering$],[$$$1059,$Mary Chua,IT$001,$FCS$,$D$,$Annie Chew,School of Engineering$],[$$$1100,$Jack Chia,IT$001,$FCS$,D,$Robin,School of Engineering$],[$$$1308,$Bobby Ching,IT$001,$FCS$,$D$,$Annie Chew,School of Engineering$],[$$$1059,$Mary Chua,ITO$02,$Database Systems,HD$,$Jason Ong,School of Design$],[$$$1056,$John $Ng,$ITO$02,$Database Systems,D$,$Jason Ong,School of Design$],[$$$1100,$Jack Chia,ITO$02,$Database Systems,C$,$Jason Ong,School of Design$],[$$$1308,$Bobby Ching,ITO$02,$Database Systems,C$,$Jason Ong,School of Design$],[$$$1100,$Jack Chia,ITO$03,$IDC,$P,$Robin,School of Engineering$],[$$$1056,$John $Ng,$IT$003,$IDC,$D,$Robin,School of Engineering$],[$$$1059,$Mary Chua,ITO$03,$IDC,D$,$Annie Chew,School of Engineering$],[$$$1308,$Bobby Ching,IT$003,$IDC,HD$,$Annie Chew,School of Engineering$],[$$$1308,$Bobby Ching,IT$004,$ICS,D$,$Robin,School of Engineering$],[$$$1059,$Mary Chua,ITO$04,$ICS,P$,$Robin,School of Engineering$],[$$$1056,$John $Ng,$ITOO$4,$ICS,HD$,$Robin,School of Engineering$],[$$$1100,$Jack Chia,ITO$04,$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$).$