Capgemini interview question

DBMS - Joins, Normalization concepts