ZS Associates interview question

Form query to normalize tables in case study