Capgemini interview question

oops concept and sql normalization