S&P Global interview question

database design