Domanda di colloquio di Cognizant

Few questions on sql query and normalisation