ATCS interview question

About join and normalisation