u2i interview question

Designing complex database and explaining the logic behind.