Impelsys interview question

Oops concepts, MySQL normalisation, joins