Oracle interview question

Given scenario, how to design solution.