BNP Paribas Interview Question

Given a particular scenario, how would you design your db