Q$\mathrm{.}5\mathrm{.}3$ The below Entity Relationship Diagram $($ERD$)$ is in second normal form. Draw a new ERD in third normal form and explain the changes.

$(7)$

Q$\mathrm{.}5\mathrm{.}4$ The below data is in first normal form. Normalise the data to third normal form, showing all steps with explanations.

Dependency diagrams or tabular data are acceptable for the final answer.

Primary key: PlayerName, SpaceshipRegistration

$\backslash$table$[[\backslash$table$[[$Player$],[$Name$]],\backslash$table$[[$Player$],[$DateJoined$]],\backslash$table$[[$Spaceship$],[$Registration$]],\backslash$table$[[$Spaceship$],[$Name$]],\backslash$table$[[$Spaceship$],[$Value$]]],[$Bob$,2014-12-31,$SWA,Big Ship,$2000000],[$Bob$,2014-12-31,$LZH$,$Medium Ship,$400000],[$Alice$,2015-05-09,$ALO,Flea,$10000]]$

$(12)$