Schneider Electric interview question

Database design