Capgemini Interview Question

oops concept and sql normalization