Oracle Interview Question

Given scenario, how to design solution.