ATCS Interview Question

About join and normalisation