CARFAX interview question

Normalization, joins, unions