u2i Interview Question

Designing complex database and explaining the logic behind.