Agilysys Interview Question

SQL questions on normalization