Table $1$: Database of student information

a$.$ Identify and state all the data problems in Table $1.[1$m$]$

b$.$ Perform preprocessing on the table following these conditions:

i$.$ For all problems identified in a$.$ suggest solutions. Explain and justify your choices. $[2$m$]$

ii$.$ For numerical attributes, normalize all the data to the range of $0,1$ using min$-$max

normalization. Assuming the minimum and maximum values for all attributes are

contained within Table $1$ and round up the values to $4$ decimal places. $[3$m$]$

c$.$ Compare every pair of students in the database using Euclidean distance. Show the full

calculation and record the results in a dissimilarity matrix. $[3$m$]$

d$.$ Comment on the outcomes of the comparison in c$.[1$m$]$