Question $2$

Figure $1.$ Client Tax Invoice

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

i$)$ Based on Figure $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 dependencles in part $($iii$)$ and transform into tables that are in $3^{rd}$

Normal Form. $($Explain the rationale for your decision$).$