Pie Infotech interview question

Normalisation and SQL basic queries