TIAA Interview Question

Couple of data modelling questions, datastage specific and SQL.