Nihilent interview question

Constraints, Joins, Views, Index, Normalization, SQL quieries