Coforge interview question

Dbms joins, normalization oops 4 pillars