Task $2-$ Normalisation $2(5$ marks$)$

The form below depicts a form used to record details of a meeting and who attended it$.$

Meeting Attendance Form

Meeting Number: $5896$ Date$/$Time: $07/09/1314$:$00$ Room: $13$A

Project Code: DV$201$ Project Title: WestCorp Mining CMS

Meeting Topic: Weekly Project Status Meeting

Attendees

Duration of Meeting: $1hr10m$

Normalise this data to the third normal form, clearly showing the stages of $0$NF$,1$NF$,2$NF and $3$NF$.$

State any assumptions you make. Use relational symbolic notation as indicated in the second lecture,

and name your resultant data sets upon reaching $3NF.$

Include a physical E$-$R diagram of your normalised results. Remember to state any assumptions

regarding the cardinality of the relationships in the diagram.