Wiley interview question

About normalization from sql and a code