Hansa Cequity interview question

Joins,normalisation forms,