Alamy interview question

Scenario based database design