write reflective journal on Normalisation including

Define normalisation and its purpose

Identify data modification anomalies

Explain functional dependence and other key database terminology

Describe the normal forms and their purpose

Analyze data for patterns and build algorithms to convert data to atomic values

Analyze and convert unnormalized data to $1$NF

Analyze and convert $1$NF data to $2$NF

Analyze and convert $2$NF data to $3$NF

Identify primary and foreign key fields

Create lookup tables