Agilysys interview question

SQL questions on normalization