Cegedim interview question

database design