Cognizant interview question

Few questions on sql query and normalisation